Sql server view not updating on line dating totally
Test Sales Order Detail'); This is my go-to DMV for statistics because in addition to including the date that statistics were last updated and row information, I also get a count of modifications since the last statistic update.
If the plan does not use a statistic, the statistic will not automatically update, even if the query modifies columns in said statistic key.The technical article, Statistics Used by the Query Optimizer in Microsoft SQL Server 2008, documents these thresholds.For a regular table, statistics are out of date when:o The table had more than 500 rows when the statistics were gathered, and the colmodctr of the leading column of the statistics object has changed by more than 500 20% of the number of rows in the table when the statistics were gathered (test 3). Sales Order Detail table has 121317 rows:(121317 * 0.20) 500 = 24764The bulk insert below loads 24775 rows, which should be enough to invalidate statistics. The statistics have not updated, but the modification counter has changed, as expected.However, after refreshing the Linked Server, refreshing Tables - the new field doesn't show up.Three other tables that were not changed that use the exact same process (Oracle consumes a SQL Server view and produces a table that is updated every 15 minutes) all work.