Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning different estimated rows on same index operation? RE: different estimated rows on same index operation?

  • March 17, 2015 at 4:25 am

    #1784439

    Take into account that table variable stats is hard coded to be 1 row where temp table has actual row count.

    This would be something to consider as Table variable might make nested loop joins occur and/or carry forward an underestimated row count..

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]