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)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
