Use -SQLAutoStats to enable Autonomous Update Statistics (AUS), which automatically updates statistics based on query activity and data changes, helping maintain optimal query performance without manual intervention.

Operating system and syntax UNIX / Windows 
-SQLAutoStats ON
Use with Maximum value Minimum value Single-user default Multi-user default
DBS — — OFF OFF
ON

Set the value of this parameter as ON, during startup, to start the Autonomous Update Statistics (AUS) service. Once the value of the parameter is set, it is remembered for the lifetime of the server and for all connections.

AUS automatically keeps SQL statistics up to date, ensuring the cost-based optimizer can select the most efficient query execution plan, which reduces the manual workload for DBA. Stale statistics can lead to suboptimal plans, causing excessive I/O, high CPU usage, memory pressure, and reduced performance/concurrency. For more information, see Autonomous update statistics.

While the database is running, you may change this parameter using PROMON or through the _DbParams VST. This change only affects the primary broker and any newly spawned servers. Changes to existing secondary brokers while the database is running require a restart.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.