Revisions to statistics are up to date, but estimate is incorrect

edited tags

Link

edited May 6, 2019 at 11:05

Aaron Bertrand

181.5k
28
402
619

Incorporated comments; edited tags

Source Link

edited Apr 21, 2017 at 3:58

Paul White ♦

90.3k
30
424
663

Update 1: The The query seems to load a total of 5 different statistics objects, all of which contain ReportID + some other columns from the table. They have all been freshly updated. RANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

sp_updatestats is scheduled to run every night to update stats.

Update 1: The query seems to load a total of 5 different statistics objects, all of which contain ReportID + some other columns from the table. They have all been freshly updated. RANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

The query seems to load a total of 5 different statistics objects, all of which contain ReportID + some other columns from the table. They have all been freshly updated. RANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

sp_updatestats is scheduled to run every night to update stats.

sql-server sql-server-2008-r2 t-sql index-statistics

added 67 characters in body

Source Link

edited Feb 26, 2015 at 16:57

user1151923

223
1
6

Update 1: The query seems to load a total of 5 different statistics objects, all of which contain ReportID + some other columns from the table. They have all been freshly updated. RANGE_HI_KEYRANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

Update 1: The query seems to load a total of 5 different statistics objects, all of which have been freshly updated. RANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

Update 1: The query seems to load a total of 5 different statistics objects, all of which contain ReportID + some other columns from the table. They have all been freshly updated. RANGE_HI_KEY in the table below is the highest upper bound column value in the histogram.

added 2130 characters in body

Source Link

edited Feb 26, 2015 at 16:43

user1151923

223
1
6

Loading

Tweeted twitter.com/#!/StackDBAs/status/570957750030770178

occurred Feb 26, 2015 at 14:45

added 4 characters in body

Source Link

edited Feb 26, 2015 at 14:01

user1151923

223
1
6

Loading

added 17 characters in body

Source Link

edited Feb 26, 2015 at 14:00

marc_s

9k
6
45
52

Loading

deleted 8 characters in body

Source Link

edited Feb 26, 2015 at 13:57

user1151923

223
1
6

Loading

Post Migrated Here from stackoverflow.com (revisions)

occurred Feb 26, 2015 at 13:56

Source Link

asked Feb 26, 2015 at 13:43

user1151923

223
1
6

Loading

Stack Exchange Network

Return to Question