indexing fields

other tip than frequent use of "where" in Querries

[henry0]

Do you use some other rules of thumbs
to decide on indexing a field other than
to determine which field to be indexed based on frequent use of WHERE in querries
knowing that one may index up to 16 fields per table

(I think that I assume correctly?)
thanks

Henry

[timster]

You should also index fields used in the ORDER BY or GROUP BY clause.

If a table has many rows, I'd index fields that have even occasional appearances in WHERE, ORDER BY, or GROUP BY fields.

Also consider whether you'd be better served with a full text index for certain fields.

[henry0]

Thanks
we might all add on our knowledge by adding on the list
then I'll do a recap

Henry