Thanks

I will see the link provided by you

ChandaMAMA

I read the article, its very interesting, what i guess is that there is no thumb rule for creating index you have to analyze data and then create index.

Its basically...

Thanks Gail for prompt reply

Your answer prompt me to ask another question.

If individual indexes work, then why we need composite indexes or which one is better individual or composite index.

I...