On Mon, May 23, 2005 at 07:41:19PM +0200, Yves Vindevogel wrote: > However, when I query my db using for instance order by pages, > documentname, it is very fast. > If I use order by pages desc, documentname, it is not fast at > all, like it is not using the index properly at all.
Make an index on "pages desc, documentname asc". /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
