Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing Order By columns - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Indexing Order By columns
Date
Msg-id 1094501687.8246.6.camel@localhost.localdomain
Whole thread Raw
In response to Indexing Order By columns  (Hadley Willan <hadley.willan@deeperdesign.co.nz>)
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: Secrétariat
Date:
Subject: Re: RAD with postgreSQL
Next
From: "Henry Combrinck"
Date:
Subject: Re: Passing RECORD variable from func1() to func2()