Thread: Indexing Order By columns

Indexing Order By columns

From
Hadley Willan
Date:
Hi all,
    Can it speed things up to index the order by columns?

Thanks.
    Hadley

Re: Indexing Order By columns

From
Christopher Browne
Date:
hadley.willan@deeperdesign.co.nz (Hadley Willan) wrote:
>     Can it speed things up to index the order by columns?

Certainly.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/linuxdistributions.html
"Microsoft is sort of a mixture between the Borg and the
Ferengi. Combine the Borg marketing with Ferengi networking..."
-- Andre Beck in dcouln

Re: Indexing Order By columns

From
"Scott Marlowe"
Date:
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 lower(name)