Processing Group by and Order by Using an Index
Original Publication Date: 1989-Aug-01
Included in the Prior Art Database: 2005-Jan-30
When a relational data base query deals with large amounts of data, the ORDER BY and GROUP BY operators allow control over and reduction of the data returned. SORT is commonly used to support ORDER BY and GROUP BY. However, quite often ORDER BY and GROUP BY can also be supported by an index.