Re: [U2] unidata index

Don't know - I wouldn't index a field for that reason alone.

And it probably wouldn't help if you had other fields you were sorting by, or other fields you were selecting, in the same select statement.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Jeffrey Butera
Sent: Thursday, March 13, 2014 2:15 PM
To: U2 Users List
Subject: [U2] unidata index

Stupid index question: does indexing a field help performance when sorting BY that field but it's not otherwise involved in the query?

--
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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
________________________________


Dave Davis
Team Lead, Research & Development

P: 614-875-4910 x108
F: 614-875-4088
E: [email protected]
        [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/>
        6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com>

This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users