Show TOC

Selects and FetchesLocate this document in the navigation structure


<number of> selects and fetches, selectivity <percentage>%: <number of> rows read, <number of> rows qualified


The strategies for accessing table data are poor for SELECT or FETCH statements. The system has to read a large number of table rows to find a small number of rows that fulfill a WHERE condition.

User Response

Find the statement that causes this poor ratio of read rows to found rows, and check the access strategies for this statement.

More Information

For information on creating optimized SQL statements, see the SQL Optimizer documentation.