Index selection for an index access path

Details Index selection for an index access path Index selection for an index access path

1997-02-28

1999-07-13

Kulik, Paul V.

Data processing: database and file management or data structures

Database design

Data structure types

707 1, 707 3, 707 4, G06F 1730

Patent

active

059240881

ABSTRACT:
A list of indexes, from which indexes are selected for an index access path, is sorted by number of columns upon which each index is built. From the sorted list of indexes, a set of index access methods is generated in a heuristically ordered set of passes from a given WHERE clause. The index access methods that comprise the index access path are selected from the set of index access methods according to a cost/benefit analysis.

REFERENCES:
patent: 5043872 (1991-08-01), Cheng et al.
patent: 5412806 (1995-05-01), Du et al.
patent: 5495608 (1996-02-01), Antoshenkov
patent: 5732258 (1998-03-01), Jakobsson et al.
patent: 5761653 (1998-06-01), Schiefer et al.
patent: 5778353 (1998-07-01), Schiefer et al.
"Oracle TextServer3 Concepts, Version 3," Oracle Corporation (Part No. A24984-1, 1995, pp. 3-1 to 3-23).
"Oracle Textserver3 Concepts, Release 3.1," Oracle Corporation (Part No. A41697-2), 1996, pp. 3-1 to 3-29.

Affiliated with

Also associated with

Rating

Index selection for an index access path does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Index selection for an index access path, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Index selection for an index access path will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2288466