Post reply

Estimated Executin Plan different between Standard Edition and Enterprise Edition

  • October 19, 2004 at 6:27 am

    #161663

    Should an Estimated Query Plan (same query) be vastly different between Standard Edition and Enterprise Edition?  Both databases are identical with data, indexes...  One is a restore from the other.  The estimated row count between the two editions is off by thousands of records. 

    The Enterprise Edition version of the database is estimating about 500 records and the Standard edition version of the same database is estimating thousands of records.  Do execution plans take into account the hardware configuration?  I didn't think so since the cost is based on percentages.

    Any help with understanding why there would be a difference in execution plans on 2 different versions of sql server is appreciated.

    Thanks 

  • October 19, 2004 at 8:37 am

    #527192

    Have you tried updating statistics on both databases?

    Run sp_updatestats and see if that fixes the issue.

    --
    Adam Machanic
    whoisactive

  • October 20, 2004 at 3:54 am

    #527288

    Does teh query use an indexed view? This will be treated differently...

  • October 20, 2004 at 4:59 am

    #527294

    Yes, the statistics have been updated on both databases prior to checking the execution plan.

    The query does not use an indexed view.

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply