Neoview Database Administrator's Guide (R2.3)

SQL>call hp_ustat.chg_auto_list('insert', '*', '*', ?);
RESPONSE
--------------------------------------------------------------------------------
INSERTed 3 table names (all) into list.
--- SQL operation complete.
• This CALL statement invokes the CHG_AUTO_LIST() procedure, which deletes all table
entries in the automated list, and the list becomes static:
SQL>call hp_ustat.chg_auto_list('delete', '*', '*', ?);
RESPONSE
--------------------------------------------------------------------------------
All entries DELETEd.
--- SQL operation complete.
• This CALL statement invokes the CHG_AUTO_LIST() procedure, which adds the sales.orders
table to the list of automated tables:
SQL>call hp_ustat.chg_auto_list('insert', 'sales', 'orders', ?);
RESPONSE
--------------------------------------------------------------------------------
Table name "SALES.ORDERS" INSERTed.
--- SQL operation complete.
• This CALL statement invokes the CHG_AUTO_LIST() procedure, which adds the sales.parts
table to the list of automated tables:
SQL>call hp_ustat.chg_auto_list('insert', 'sales', 'parts', ?);
RESPONSE
--------------------------------------------------------------------------------
Table name "SALES.PARTS" INSERTed.
--- SQL operation complete.
• This CALL statement invokes the CHG_AUTO_LIST() procedure, which deletes the
sales.parts table from the automated list:
SQL>call hp_ustat.chg_auto_list('delete', 'sales', 'parts', ?);
RESPONSE
--------------------------------------------------------------------------------
Table name "SALES.PARTS" DELETEd.
--- SQL operation complete.
Listing the Automated Tables
To list the tables on which UPDATE STATISTICS runs automatically and to display when
UPDATE STATISTICS was last run on a table and if there were errors, query these views:
• “HP_USTAT.USTAT_AUTO_LIST View” (page 106)
• “HP_USTAT.USTAT_AUTO_LIST_DETAIL View” (page 106)
Listing the Automated Tables 105