Query plan selection control using run-time association...

Details Query plan selection control using run-time association... Query plan selection control using run-time association...

2005-04-05

2009-12-29

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07640230

ABSTRACT:
A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.

REFERENCES:
patent: 5812996 (1998-09-01), Rubin et al.
patent: 6356887 (2002-03-01), Berenson et al.
patent: 6366901 (2002-04-01), Ellis
patent: 6615203 (2003-09-01), Lin et al.
patent: 6985904 (2006-01-01), Kaluskar et al.
patent: 7139749 (2006-11-01), Bossman et al.
patent: 2002/0198896 (2002-12-01), Chaudhuri et al.
patent: 2003/0225768 (2003-12-01), Chaudhuri et al.
patent: 2004/0162822 (2004-08-01), Papanyan et al.
patent: 2004/0236762 (2004-11-01), Chaudhuri et al.
patent: 2005/0097091 (2005-05-01), Ramacher et al.
patent: 2005/0125398 (2005-06-01), Das et al.
patent: 2005/0125452 (2005-06-01), Ziauddin et al.
patent: 2005/0262072 (2005-11-01), Chen et al.
patent: 2006/0004696 (2006-01-01), Day et al.
patent: 2007/0106553 (2007-05-01), Jordan et al.
Antara Ghosh, Jignashu Parikh, Vibhunti Sengar, Jayant Haristsa, Plan Selection based on Query Clustering, 2002, ACM.
Timos K. Sellis, Multiple Query Optimization, ACM Transactions on Database Systems, vol. 13, No. 1, Mar. 1988, pp. 23-52.
Execution Plan Caching and Reuse, Microsoft.com Library, SQL Server Architecture, http://www.msdn.microsoft.com/library/en-us/architec/8—ar—sa—4azp.asp?frame=true, last viewed Aug. 10, 2005.
Arun Marathe, Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005, http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx, last viewed Aug. 10, 2005.
Oracle9i, SQL Reference, Release 2 (9.2), Oct. 2002, pp. 48-51.

Affiliated with

Also associated with

Rating

Query plan selection control using run-time association... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query plan selection control using run-time association..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query plan selection control using run-time association... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4096812