more unintuitive behavior

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: arthur (alangham_at_gmail.com)
Date: 02/15/05 

Date: 15 Feb 2005 06:15:21 -0800

i just updated statistics (with fullscan) on a set of tables that are
referenced by a query, and now, the query runs slower than it did
before i updated the statistics. so,

1. has anyone seen this before?
2. can anyone explain this?

thanks,

arthur

Relevant Pages

  • Re: index bloat?
    ... Did you also update statistics (WITH FULLSCAN) on loan_history? ... > Was that a typo and you meant to say it sounds like a good plan? ... how can I get the query optimizer to generate it - ...
    (comp.databases.ms-sqlserver)
  • Re: WHERE clause question
    ... > no reason that select * with where should run slower. ... There are two parts to executing a query. ... SQL Server can start spooling rows as soon as it finds matches and has the ... if the statistics is outdated, ...
    (microsoft.public.sqlserver.programming)
  • Re: Leftmost column in an index
    ... That's one example where the optimizer creates these _WA% statistics to ... which is the cost of a table scan. ... But this query: ... >> would likely change to a table scan or clustered index scan. ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange Cost Based Optimizer Decision Making
    ... The statistics on this table are 100% completely up to ... > I run an identical SELECT clause to the last query against this table. ... > the stats are fully up to date for LARGE_TABLE. ... compare that number with clustering factor and number ...
    (comp.databases.oracle.server)
  • Re: Planning multiple queries
    ... > so it seems to me a new plan should be prepared for the second query, ... If you submit them all in one batch, SQL Server generates a query plan ... If no statistics get updated as result of the query, ...
    (comp.databases.ms-sqlserver)