On Wed, 30 Oct 2002, Stephan Szabo wrote:
> On 29 Oct 2002, Ives Landrieu wrote:
>
> > Hi,
> >
> > Can anybody explain the following results when using EXPLAIN,
> > one time with enable_seqscan=on and one time with enable_seqscan=off.
> > What I don't understand is that the nodes created are the s
On 29 Oct 2002, Ives Landrieu wrote:
> Hi,
>
> Can anybody explain the following results when using EXPLAIN,
> one time with enable_seqscan=on and one time with enable_seqscan=off.
> What I don't understand is that the nodes created are the same
> (index scan, seq scan), but the costs differ.
Ena
Hi,
Can anybody explain the following results when using EXPLAIN,
one time with enable_seqscan=on and one time with enable_seqscan=off.
What I don't understand is that the nodes created are the same
(index scan, seq scan), but the costs differ.
set enable_seqscan=on;
explain (SELECT alias96.I