Which of the following is the fastest query method for a table?

Options
- Fetch by columnid
- Fetch by tableid
- Fetch by rowid
- Fetch by indexid


CORRECT ANSWER : Fetch by rowid

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

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement