Timeline for Why does SQL Server refuse to update these statistics with anything but fullscan?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 23, 2016 at 12:43 | vote | accept | Martin Smith | ||
| Jan 22, 2016 at 22:13 | comment | added | Martin Smith | Yes it definitely looks like something fixed in later versions. I produced a simple repro here pastebin.com/7f4TwmKW and on a test server running 11.0.5343.0 found my request for a sample size of 10,000 rows was ignored and all 8,000,000 rows sampled i.sstatic.net/DbbjZ.png (plan much the same as the one in the question) - But I don't encounter this on Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (rows sampled there is 274,649 which is pretty close to the estimated number of rows in the earlier build and the plan uses the CI rather than the columnstore.) | |
| Jan 22, 2016 at 22:07 | vote | accept | Martin Smith | ||
| Jan 22, 2016 at 22:17 | |||||
| Jan 22, 2016 at 13:36 | comment | added | Martin Smith |
(Regarding the last paragraph) SELECT WebAnalyticsId, MarketKey from [dbo].[factWebAnalytics] TABLESAMPLE (897667 ROWS) ORDER BY MarketKey, WebAnalyticsId runs in less than 30 seconds for me. It doesn't use the columnstore index though. It uses the clustered index.
|
|
| Jan 22, 2016 at 13:29 | history | answered | Paul White♦ | CC BY-SA 3.0 |
