SQL Server Performance

FULLSCAN vs Default

Discussion in 'Performance Tuning for DBAs' started by alexlg, Apr 29, 2008.

  1. alexlg New Member

    Here's an interesting one that I can't fathom.
    I have updated a large DB with UPDATE STATISTICS WITH FULLSCAN. However, the queries run much faster if I run a simple UPDATE STATISTICS. The query plans bear this out - one of the queries takes 5 mins after the FULLSCAN but 30 seconds after updating the stats without any options.
    I've looked at the fragmentation of the indexes and all seems well. So what situations produce this behaviour of a FULLSCAN producing duff query plans?
  2. MohammedU New Member

    Welcome to the forum...
    What index the query is using after FULLSCAN vs default?
    Based on the available stats optimizer might be using different index resulting the query to run slow...
  3. satya Moderator

Share This Page