US 2012/0084315 A1 · Query Plan Optimization for Prepared SQL Statements

Abstract

System, methods and articles of manufacture for optimizing a query plan reuse in a database server system accessible by a plurality of client connections. An embodiment comprises providing at least one global cache storage and a private cache storage to a plurality of client connections, and coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures and query plans for prepared SQL statements across the plurality of client connections via the at least one global cache storage while avoiding a spinlock access for executing the prepared SQL statements.

Claims20

Dependent claims

A method for optimizing a query plan reuse in a database server system, comprising:

providing at least one global cache storage and a private cache storage to a plurality of client connections;
and
coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures (LWPs) and query plans for prepared SQL statements across the plurality of client connections via the at least one global cache storage while avoiding a spinlock access for executing the prepared SQL statements.

A database server system for optimizing a query plan reuse comprising:

a first global cache storage configured to store a plurality of LWPs;
a second global cache storage configured to store a plurality of query plans, wherein the first and second global cache storage are accessible to a plurality of client connections;
a local cache storage configured to store a subset of LWPs wherein the subset of LWPs is associated with one client connection of the plurality of client connections;
and
a coordination module configured to access the first and second global cache storage and the local cache storage and determine if a query plan for a prepared SQL statement generated by at least one client connection of the plurality of client connections exists in the database server system and avoid an access spinlock for executing the prepared SQL statement.

2 more elements

Dependencies are inferred from the claim text.

Query Plan Optimization for Prepared SQL Statements

Life of this patent

Query Plan Optimization for Prepared SQL Statements

Life of this patent

Abstract

Claims20