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