ADMINISTRATION OF THE DATABASE

This chapter covers topics related to the administration of the database. The topics include the following:

• Accessing information about the database by using TEXIS's system catalog.

• TEXIS reserved words to avoid in naming tables and columns.

• System Catalog
• Optimization
  • Table Compaction
  • Index Maintenance
    • Manual Index Optimization via CREATE METAMORPH INDEX
    • Manual Index Optimization via ALTER INDEX
    • Automatic Index Optimization via chkind
    • Choosing Manual vs. Automatic Index Optimization
• Reserved Words
• Server Properties
  • Search and optimization parameters
  • Metamorph parameters
  • Rank knobs
  • Other ranking properties
  • Indexing properties
  • Locking properties
  • Miscellaneous Properties