System and method for forcing a query execution plan

Details System and method for forcing a query execution plan System and method for forcing a query execution plan

2005-04-28

2008-12-09

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07464071

ABSTRACT:
A suggested query execution plan is used as a constraint on a guided optimization process such that all execution plans that do not conform to the suggested execution plan are eliminated as possible alternatives. If the guided optimization process successfully generates a resulting execution plan, then the result will conform to the suggested execution plan. If the guided optimization process fails to generate a resulting execution plan, then it may be determined that the suggested execution plan is invalid.

REFERENCES:
patent: 7167859 (2007-01-01), Shah et al.
patent: 2002/0055932 (2002-05-01), Wheeler et al.
patent: 2003/0009446 (2003-01-01), Agarwal et al.
patent: 2003/0093410 (2003-05-01), Couch et al.
patent: 2003/0182276 (2003-09-01), Bossman et al.
patent: 2004/0019587 (2004-01-01), Fuh et al.
patent: 2006/0031189 (2006-02-01), Muras et al.
Mihnea Andrei, Patrik Valduriez, User-Optimizer Communication using Abstract Plans in Sybase ASE, 2001, 27th VLDB Converence; Sections 1-5.

Affiliated with

Also associated with

Rating

System and method for forcing a query execution plan does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for forcing a query execution plan, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for forcing a query execution plan will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4038614