Indexing Order By columns

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&gt; 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

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)