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

Reply via email to