The index is in sorted order. If you want to sort only on the field, then the list returned is in sort order. So: select file with field = "[xx" - indexed field list file field field2 field3 - will be sorted on field.
Groete, Regards, Christo van Rooyen GT - Systems Analyst / Designer II - Nedbank Limited Mobile: 082 925 6301 Office: 012 436 7264 Location: MenLyn Maine - 3'rd Floor - Desk 292 -----Original Message----- From: Jeffrey Butera [mailto:jbut...@hampshire.edu] Sent: 13 March 2014 08: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 ******************** Nedbank Limited Reg No 1951/000009/06. The following link displays the names of the Nedbank Board of Directors and Company Secretary. [ http://www.nedbank.co.za/terms/DirectorsNedbank.htm ] This email is confidential and is intended for the addressee only. The following link will take you to Nedbank's legal notice. [ http://www.nedbank.co.za/terms/EmailDisclaimer.htm ] ******************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users