Discussion Board

Fetch by rowid Fetch by rowid is the fastest query method for a table. The "table fetch by rowid" Oracle metric occurs when rows are fetched using a ROWID (usually recovered from an index), each row returned increments this counter. This statistic is an indication of row fetch operations being performed with the aid of an index. Because, doing table scans usually indicates either non-optimal queries or tables without indexes, this statistic should increase as the above issues have been addressed in the application. Prajakta Pandit 02-9-2017 02:05 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*