Index on Group By Variables

foosh101 · Post by **foosh101** » Fri May 02, 2003 11:41 am

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?

Post by **John** » Fri May 02, 2003 12:41 pm

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.

foosh101 · Post by **foosh101** » Tue May 06, 2003 12:23 pm

FYI - I added the GROUP BY field to my compound index, and it increased the speed of my search by over %500.