Method and apparatus for optimizing queries having group-by oper

Details Method and apparatus for optimizing queries having group-by oper Method and apparatus for optimizing queries having group-by oper

1996-05-28

1997-01-28

Amsbury, Wayne

Boots, shoes, and leggings

364DIG1, 3642821, 3642834, G06F 1730

Patent

active

055985599

ABSTRACT:
A method and apparatus for optimizing a query for a relational database are disclosed. The techniques employed enable a group-by operator to be an internal node. In particular, the optimization techniques include the steps of receiving a query having group-by to be optimized, generating for the query execution plans where placing group-by preceding every internal join node are considered, estimating cost for the execution plans, and choosing the execution plan having the lowest estimated cost.

REFERENCES:
patent: 5448727 (1995-09-01), Annenelink
patent: 5469568 (1995-11-01), Schiefer et al.
patent: 5495605 (1996-02-01), Cadot

Affiliated with

Also associated with

Rating

Method and apparatus for optimizing queries having group-by oper does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for optimizing queries having group-by oper, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for optimizing queries having group-by oper will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-947778