FETCH
Short Description
The FETCH operator represents fetching specific rows from a table using RID
Detailed Description​
The FETCH operator represents fetching rows from a table by use of physical address - known as row ID or RID.
If the all the columns required by the query are covered by supporting indexes, performance can be improved by removing access to the table altogether.
If possible, increase the size of the buffer to cover all pages read from disc.
Ensure the statistics are up to date with the RUNSTATS command so that the optimizer has the best chance of planning an efficient access path.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.