Re[2]: Weird indices

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