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

Reply via email to