Browse Prior Art Database

Processing Group by and Order by Using an Index

IP.com Disclosure Number: IPCOM000037903D
Original Publication Date: 1989-Aug-01
Included in the Prior Art Database: 2005-Jan-30

Publishing Venue

IBM

Related People

Authors:
Cheng, JM Shibamiya, A Wang, Y [+details]

Abstract

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.