3 ms·
The statistics are not updated on SELECT, but when: - one or more rows are added to an empty table - more than 500 rows are added to a table with less than 5
by AdrianB1 5y ago
The statistics are not updated on SELECT, but when:
- one or more rows are added to an empty table
- more than 500 rows are added to a table with less than 500 rows
- more than 500 rows are added to a larger table and the number of rows added is larger than a percentage that depends on the table size (20% under 25,000 rows, 0.1% for 1 billion rows, several values in between)
- when indexes are rebuilt, the associated statistic is rebuilt