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