Refreshing an execution plan for a query

Details Refreshing an execution plan for a query Refreshing an execution plan for a query

2006-10-30

2009-06-16

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07548905

ABSTRACT:
An improved system and method for storing, reusing and recompiling execution plans for SQL database queries. The system. The system validates the performance of a newly compiled plan prior to replacing a currently stored execution plan and compares the resource cost of the recompiled plan with the cost of the currently stored plan. In the event that the resource cost of the recompiled plan is not greater than the stored plan resource cost, the system replaces the currently stored execution plan with the recompiled plan.

REFERENCES:
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 2004/0220923 (2004-11-01), Nica
patent: 2007/0192296 (2007-08-01), Burger et al.
patent: 2007/0208695 (2007-09-01), Burger et al.
patent: 2008/0052266 (2008-02-01), Goldstein et al.
patent: 2008/0189243 (2008-08-01), Li et al.
patent: 2008/0215531 (2008-09-01), Markl et al.

Affiliated with

Also associated with

Rating

Refreshing an execution plan for a query does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4147023