The most important performance indicator in this area of the Database Monitor is Table scans.

Scans should be kept to a minimum, as a high number of sequential table scans can be detrimental to database performance.

Use Bottleneck Analysis to determine which tables are being scanned frequently.

To reduce the number of table scans, you can:

• Ensure that the required table columns are indexed
• Rewrite the requesting SQL statements so that full table scans are no longer required