Hybrid optimization strategies in automatic SQL tuning

Details Hybrid optimization strategies in automatic SQL tuning Hybrid optimization strategies in automatic SQL tuning

2011-07-12

2011-07-12

LeRoux, Etienne P (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

07979422

ABSTRACT:
Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.

REFERENCES:
patent: 2005/0262046 (2005-11-01), Day et al.

Affiliated with

Also associated with

Rating

Hybrid optimization strategies in automatic SQL tuning does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Hybrid optimization strategies in automatic SQL tuning, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Hybrid optimization strategies in automatic SQL tuning will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2664907