Neoview Database Administrator's Guide (R2.5)

5 Automating Update Statistics and Reorganize Operations.....................................25
Setting Tables for Automated UPDATE STATISTICS...........................................................................25
HP_USTAT.CHG_AUTO_LIST() Stored Procedure........................................................................25
Syntax.........................................................................................................................................25
Considerations............................................................................................................................26
Examples....................................................................................................................................27
Listing the Automated Tables...............................................................................................................28
HP_USTAT.USTAT_AUTO_LIST View...........................................................................................28
HP_USTAT.USTAT_AUTO_LIST_DETAIL View............................................................................28
Stopping Automated UPDATE STATISTICS........................................................................................29
HP_USTAT.STOP_AUTOMATED_STATS() Stored Procedure.......................................................29
Syntax.........................................................................................................................................29
Considerations............................................................................................................................29
Example......................................................................................................................................29
Scheduling Automated UPDATE STATISTICS and REORG Using NCI.............................................30
SCHEDULE Command...................................................................................................................30
6 Managing Client Data Sources and Connectivity....................................................31
For More Information About Neoview Connectivity...........................................................................31
Reconfiguring ODBC Client Data Sources...........................................................................................31
Configuring ODBC Client Data Sources for Update Operations.........................................................31
Removing ODBC Client Data Sources..................................................................................................31
Neoview Database Connectivity Services (NDCS)...............................................................................32
Glossary............................................................................................................................33
Index.................................................................................................................................35
4 Table of Contents