ROWID efficiency

This report block shows how efficient direct row access is used. Direct row access is very fast because DB2 does not use an index or table space scan to find the row.

The TABLE SPACE SCAN USED field value should be zero. Use the WHERE clause to cause an unsuccessful direct row access to revert to a matching index scan using the primary key:

WHERE rowidcol=:HVROWID AND pkcol=:HVPK