Donnie Carvajal (8/1/2013)
Thanks again.Is the goal to get the actual number of rows and estimated number of rows to be equal?
Donnie
An exact match is not necessary. In fact, it is probably difficult to get them exact across the board. The target is to get them close so that the optimizer can compile an efficient plan. The estimates for rows is done by using statistics and when they are out of synch the optimizer will not create a plan that is optimal for the actual data.
--edit--
fixed some grammar issues...probably created new ones in the process.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/