Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Duplicate
-
None
-
None
-
None
Description
Scenario with low value for phoenix.stats.minUpdateFrequency so update statistics can be called in short interval:
1. Inserted 1M rows in a table T.
2. update statistics T which generated 40 guideposts in SYSTEM.STATS.
3. Executed delete from T
4. update statistics T
5. Got UPDATE STATISTICS finished successfully message in server logs
Result: 40 Gideposts are still in SYSTEM.STATS table for table T.