Group by and distinct sort elimination using cost-based optimiza

Details Group by and distinct sort elimination using cost-based optimiza Group by and distinct sort elimination using cost-based optimiza

1997-02-28

1998-10-13

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 1, 707 3, 707 4, 707 5, 707 6, 707 7, G06F 1730

Patent

active

058227482

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.

REFERENCES:
patent: 5301317 (1994-04-01), Lohman
patent: 5666526 (1997-09-01), Reiter
patent: 5668987 (1997-09-01), Schneider
patent: 5671403 (1997-09-01), Shekita
patent: 5680602 (1997-10-01), Bloem
patent: 5734884 (1998-03-01), Eberhard

Affiliated with

Also associated with

Rating

Group by and distinct sort elimination using cost-based optimiza does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Group by and distinct sort elimination using cost-based optimiza, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Group by and distinct sort elimination using cost-based optimiza will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-327083