Re: [U2] unidata index
"Van Rooyen, C. (Christo)" <[email protected]> Fri, 14 Mar 2014 05:54:49 +0000
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <48CF6B810643AD46B442069943495C55286361@EXMB105WDN02.africa.nedcor.net> |
Only if the field is the only sort 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:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users