Syntax documentationOptimizing the SQL Access to a Database Locate this document in the navigation structure

Standard Commands

DBM Command

Description

auto_recreate_bad_index

Recreating bad indexes automatically

auto_update_statistics

Updating the optimizer statistics automatically

sql_updatestat

Updating the optimizer statistics

sql_updatestat_per_systemtable

Updating the optimizer statistics as per system table SYSUPDSTATWANTED