Stupid question of the day on unidata 7.2.x

I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files:


SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS
SELECT ANOTHER_FILE BY SORT_FIELD

I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second?

--
Jeffrey Butera, PhD
Associate Director for Applications and Web Services
Information Technology
Hampshire College
413-559-5556

http://www.hampshire.edu
http://www.facebook.com/hampshirecollegeit

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to