I didn't realize that the order made a difference. A sign of how much learning I need to do. :p For reference, I think 'file_parent_dir' and 'fs_parent_dir' are the most important because I do an 'ORDER BY [fs|file]_parent_dir ASC' on most queries. I've made the changes, thank you again!

If you SELECT ... WHERE condition on A order by B :

an index on A will be used, but an index on B won't

        If you SELECT ... WHERE condition on A order by A, B :

an index on A,B will be used because it will give the rows in already sorted order

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to