Hello,
2009/11/25 Richard Neill <rn214(at)cam(dot)ac(dot)uk>:
Also, if you find odd statistics of freshly analyzed table - try
increasing statistics target, using
ALTER TABLE .. ALTER COLUMN .. SET STATISTICS ...
If you're using defaults - it's again low for large tables. Start with
200, for example.
Best regards,
Sergey Aleynikov