Index Management
The indexes in your database are absolutely the single most important determinant in the performance of the OLTP database. An awful database design that has a good index structure will almost always out-perform a wonderful design that is indexed poorly. The importance of indexes becomes more important as the table sizes get larger.
Indexes seem to be even more of a "black box" than tables. DBAs often do not understand the actual layout of the indexes. Books have been written about different methods of indexing, so the area can be somewhat intimidating. For our purposes, a simple explanation of the indexing mechanism should suffice.
B+tree Indexes
Informix indexes use the b+tree method of indexing. Basically, this is a method ...
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.
