On Wed, 3 Dec 2003, Ferdinand Smit wrote:
> Hi,
>
> When trying to explain a developer of our organisation the reson why the index
> was'nt used, i was confused my self.
>
> The simple question is: Why does the analyzer only use the index when the
There are a fiew things going on:
First, the st
Hi,
When trying to explain a developer of our organisation the reson why the index
was'nt used, i was confused my self.
The simple question is: Why does the analyzer only use the index when the
table has a few differend values ?
As you can see, when de seqscan is off, the query is mutch faster
