Table Management

The tables are the reason for the existence for the database system. Using the "black box" theory of databases, users tend to believe that once they have created a table, everything is automatically taken care of and handled by the omnipotent and omniscient database management system. For the user, it is often enough to allow his understanding to stop at this point. Ask a user where his data resides, and you'll probably get "in a table" as an answer.

One of the most important DBA functions is the arrangement and management of the tables and indexes in the database system. Unless the basic requirements of efficient table and index layout are achieved, the entire system starts off at a disadvantage and optimum performance becomes ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.