Limiting result sets with FETCH FIRST and OPTIMIZE FOR

(Alexander Kuznetsov) Let us consider a very common situation. A GUI application issues a query, then the first 25 rows from the result set are displayed on screen. If the user presses Page Down, then the next 25 rows will be displayed, and so on. It is well known that FETCH FIRST 25 ROWS and OPTIMI

Read More - Register for Free Membership