Pattern matching and range scans used; performance slow.

Use ISAM or B-tree instead.

Partial key of multi-column key used; performance slow.

Use ISAM or B-tree instead.

Overflow pages occur in table after adding rows.

Remodify.

Overflow pages occur in newly modified table.

If key is repetitive, this is normal but undesirable. If key is unique, hashing algorithm does not distribute data well; try increasing minpages. If column is a character column that only partially varies (for example, AAAAA1 AAAAA2), consider using ISAM instead.