Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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.

asked 23 Apr '21, 14:24

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050
accept rate: 20%

2

I do not think there is currently a way to get this information. If that is the case, I will investigate getting this added to a future EBF.

(27 Apr '21, 10:01) Chris Keating

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

permanent link

answered 08 May '21, 18:04

Chris%20Keating's gravatar image

Chris Keating
8.0k50131
accept rate: 32%

converted 12 May '21, 13:47

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×2

question asked: 23 Apr '21, 14:24

question was seen: 786 times

last updated: 08 May '21, 18:04