Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
7.0.0
-
None
-
1
Description
In Cheshire-Cat, CBO relies on statistics gathered through UPDATE STATISTICS command for proper cost calculations. The responsibility for running UPDATE STATISTICS is on the user. The query team is considering Auto-Update-Statistics as a new enhancement for next release. Basically the query engine will keep track of and monitor changes to the index keys, and once the mutation count exceeds a certain threshold, a new UPDATE STATISTICS command will be run in the background to refresh index and distribution statistics.
Attachments
Issue Links
- is cloned by
-
MB-53814 Expose mutation count for index keys - for MOI storage
- Open
Gerrit Reviews
For Gerrit Dashboard: MB-46775 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
178682,1 | MB-46775:Expose mutation count for index keys | unstable | indexing | Status: NEW | 0 | 0 |