Invention Grant
- Patent Title: Query plan optimization for prepared SQL statements
-
Application No.: US14635882Application Date: 2015-03-02
-
Publication No.: US10176222B2Publication Date: 2019-01-08
- Inventor: Peter J. Schneider , Hui Zhang
- Applicant: Sybase, Inc.
- Applicant Address: US CA Dublin
- Assignee: SYBASE, INC.
- Current Assignee: SYBASE, INC.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Disclosed herein are system, method, and computer program product embodiments for optimizing a query plan reuse in a database server system accessible by a plurality of client connections. An embodiment comprises determining if a query plan in a global cache storage is reserved by a client connection of a plurality of client connections, generating a cloned query plan from the query plan based on the determining, and associating the cloned query plan with a second client connection of the plurality of client connections.
Public/Granted literature
- US20150169689A1 Query Plan Optimization for Prepared SQL Statements Public/Granted day:2015-06-18
Information query