Re: [GENERAL] Indexing Order By columns

On Sun, 2004-09-05 at 16:30, Hadley Willan wrote: > Hi all, > Can it speed things up to index the order by columns? Yes, note that you need to index on what function you might be sorting by as well: create index test_dx on test (lower(name)); will allow indexes to be used on an order by lowe

Re: [GENERAL] Indexing Order By columns

[EMAIL PROTECTED] (Hadley Willan) wrote: >     Can it speed things up to index the order by columns? Certainly. -- If this was helpful, rate me http://cbbrowne.com/info/linuxdistributions.html "Microsoft is sort of a mixture between the Borg and the Fere