Repair options are available for each option.
The -pk option performs the same checks as the -ci option. (See Check Index Node Links with -ci and -cI.) In addition, -pk displays the key values for all indexes on the specified table as it checks them.
The -pK option performs the same checks as the -cI option. The -pK option displays the key values and rowids as it checks them.
The -pl option performs the same checks as the -ci option and displays the key values, but it checks only leaf-node index pages. It ignores the root and branch-node pages. See Structure of B-Tree Index Pages.
The -pL option performs the same checks as the -cI option and displays the key values and rowids, but it checks only leaf-node index pages. It ignores the root and branch-node pages.
oncheck -pL -n stores_demo.customer
The following example displays information about all indexes on the customer table:
oncheck -pl -n stores_demo:customer
The following example displays information about the index zip_ix, which was created on the customer table:
oncheck -pl -n stores_demo:customer#zip_ix
By default, the database server does not place a shared lock on the table when you check an index with the oncheck -pk, -pK, -pl, or -pL options unless the table uses page locking. For absolute assurance of a complete index check, you can execute oncheck with the -x option. With the -x option, oncheck places a shared lock on the table, and no other users can perform updates, inserts or deletes until the check has completed. For more information on option -x, see Turn On Locking with -x.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]