Apparatus and method for using values from a frequent values...

Details Apparatus and method for using values from a frequent values... Apparatus and method for using values from a frequent values...

2007-12-25

2007-12-25

Alam, Hosain (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10815231

ABSTRACT:
A database query optimizer determines when no optimal index for a query exists, determines whether a sub-optimal index exists, and if so, uses statistical information for each additional key in the sub-optimal index to rewrite the query in a manner that allows traversing the sub-optimal index. The sub-optimal index is then probed using the rewritten query, and the number of estimated returned rows is then used to optimize the query.

REFERENCES:
patent: 6513028 (2003-01-01), Lee et al.
patent: 2004/0122845 (2004-06-01), Lohman et al.
patent: 2004/0225639 (2004-11-01), Jakobsson et al.
patent: 2005/0097084 (2005-05-01), Balmin et al.

Affiliated with

Also associated with

Rating

Apparatus and method for using values from a frequent values... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for using values from a frequent values..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for using values from a frequent values... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3897410