Re: 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 lower(name)