Stephan,
Ref : Saturday, February 17, 2001 1:50:32 AM
SS> Do you have a value that is not null that is very common?
SS> It's estimating that there will be 10113 rows that match
SS> nomsession='xxx' which makes a seq scan a much less bad plan.
At first, I thought that couldn't be the case but we happen to have
100000 records where nomsession=''
Just updated them so that their value is null and everything runs
fine. Thanks for your help !
--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Perl, PostgreSQL