Page 1 of 1
Index on Group By Variables
Posted: Fri May 02, 2003 11:41 am
by foosh101
Everything I have read and heard indicates that you should index any field that you do a 'where' or 'order by' on. Is this also true for 'group by's or does it not matter?
Index on Group By Variables
Posted: Fri May 02, 2003 12:41 pm
by John
It depends on the rest of the query. If you are doing LIKE queries, putting the GROUP BY field as a compound field in the Metamorph index can help. Generally though a separate index on the field will not help much.
Index on Group By Variables
Posted: Tue May 06, 2003 12:23 pm
by foosh101
FYI - I added the GROUP BY field to my compound index, and it increased the speed of my search by over %500.