cancel
Showing results for 
Search instead for 
Did you mean: 

How do I determine if StatisticsCleaner = ON or OFF?

Breck_Carter
Participant
893

How do I determine the current value of the following sa_server_option settings?

DropBadStatistics YES, NO
Allows automatic statistics management to drop statistics that return bad estimates from the database.

DropUnusedStatistics YES, NO
Allows automatic statistics management to drop statistics that have not been used for 90 consecutive days from the database.

StatisticsCleaner ON, OFF
The statistics cleaner fixes statistics that give bad estimates by performing scans on tables. By default the statistics cleaner runs in the background and has a minimal impact on performance. Turning off the statistics cleaner does not disable the statistic governor, but when the statistics cleaner is turned off, statistics are only created or fixed when a query is run.

Accepted Solutions (1)

Accepted Solutions (1)

chris_keating
Product and Topic Expert
Product and Topic Expert

This has been fixed in SQL Anywhere 17.0 Build 6307 or newer as Engineering Case #824639.

Answers (0)