No
-----Original Message----- From: Jeffrey Butera <jbut...@hampshire.edu> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Thu, Oct 18, 2012 5:39 am Subject: [U2] Speeding sort 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
