I have a view that has something like this: select x, y, z from tbl order by x, y
I have created a special index on x + y
I have run analyze
Still, when I use explain, pg says it will first sort my tables instead of using my index
How is that possible ?
When I do explain select x,y,z from tbl order by x, y, it works like I want it to work
Met vriendelijke groeten,
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]