Group by and distinct sort elimination using cost-based optimization
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Oct 13, 1998
Grant Date -
N/A
app pub date -
Feb 28, 1997
filing date -
Feb 28, 1997
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
Sort plus operations such as 'group by' and 'distinct' generally require sorting of the retrieved data before performing the sort plus operation. A method and apparatus is disclosed for executing a query specifying a sort plus operation without performing the sorting operation. A cost-based optimizer determines at least one execution path where the data is retrieved from a sorted source and the data is processed to satisfy the query without sorting. Execution costs are determined for the respective execution paths, and the execution path having the lowest overall execution cost is selected to process the query.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully