Optimizing SQL Access to the Database Instance

Standard Commands

DBM Command

Description

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