Hi,
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,
<bold>Yves Vindevogel</bold>
<bold>Implements</bold>
<smaller>
</smaller>Hi,
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
<smaller>
Mail: yves.vindevogel@implements.be - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
<italic><x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you.
Then you win.
Mahatma Ghandi.</x-tad-smaller></italic></smaller>
Mail: yves.vindevogel@implements.be - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
First they ignore you. Then they laugh at you. Then they fight you.
Then you win.
Mahatma Ghandi.