create index ixTest on table1 (pages desc, documentname)
gives me a syntax error
On 23 May 2005, at 20:03, Steinar H. Gunderson wrote:
On Mon, May 23, 2005 at 07:41:19PM +0200, Yves Vindevogel wrote:Met vriendelijke groeten,
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
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
<<inline: Pasted Graphic 2.tiff>>
Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
<x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings