Observation: Indexes Defined for Small Table


The number of active table pages is fewer than the minimum accepted to define indexes on a table. The DB2 optimizer will not likely use an index when the number of data pages is 7 or less. However, the same index could negatively impact the performance of other operations, including INSERT, DELETE, and UPDATE operations.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI iStrobe Web 20.14