I can't say definitively, but I would expect the answer to be 'no'. On Thu, Oct 18, 2012 at 6:39 AM, Jeffrey Butera <jbut...@hampshire.edu>wrote:
> 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<http://www.facebook.com/hampshirecollegeit> > > ______________________________**_________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/**mailman/listinfo/u2-users<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
