Subject Compound Index or Individual Column Indices - Which one are better for Performance
Author R. S. Patil
Dear Friends,

I have some tables which need frequently to be queried and some of its
fields (Columns) are
used in where as well in order clause similarly on one or two columns i
need to have min and
max, count functions.

For most common fields i have defined compound index (i.e. many fields
separated by comma)
where ever i got performance hits. As data grows other queries are
slowing down. So i am
thinking of defining individual column indexes on column which are
mostly used may be
6 to 10 column i have identified which are being used in almost 80 to 90
% queries.

will defining individual indices will give me performance gains ?

what's logic in selects is used internally.

Any good reading material on index designing will be suitable for me.

Plz help me out.

R. S. Patil