Harry Rossignol <harrywr2@comcast.net> wrote:
> I'm just a lowly end user. Bumping the default statistics target
> or using ALTER TABLE SET STATISTICS has made large differences in
> query performance on large tables.
The default has been bumped up in later versions, so that shouldn't
be as big a problem as it once was. In this particular case the
EXPLAIN ANALYZE showed the estimated row counts were quite accurate
compared to the actual, so this definitely wasn't the problem this
time.
-Kevin
