Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

cache_estimated_value_plans option

Controls whether cached plans are optimized using value estimates.

Allowed values

On, Off

Default

On

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

If set to On, cached plans are optimized using value estimates influenced by the actual values provided with the statements when the plan was cached. If set to Off, cached plans are optimized independently of the actual values provided.

Note

Off corresponds to the behavior in versions 16 and earlier of the software.