Query Plan Optimization for Prepared SQL Statements
作者： Peter J. Schneider , Hui Zhang
DOI:
关键词:
摘要: System, methods and articles of manufacture for optimizing a query plan reuse in database server system accessible by plurality client connections. An embodiment comprises providing at least one global cache storage private to connections, coordinating utilization the share light weight stored procedures plans prepared SQL statements across connections via while avoiding spinlock access executing statements.
google.co.uk 参考文章(25)
Sunil Sayyaparaju, Amit Anantrao Pathak, Distributed Transaction Management in a Distributed Shared Disk Cluster Environment ,(2009)
Sihem Amer-Yahia, Dan Suciu, Divesh Srivastava, Distributed evalulation of directory queries using a topology cache ,(2001)
Jie-Bing Yu, Biswadeep Nag, Jignesh M. Patel, Jian-Jun Chen, Navin Kabra, Method and apparatus for parallel execution of sql from stored procedures ,(1999)
Chon Hei Lei, Query optimization on VPD protected columns ,(2007)
Jr. Felipe Carino, Plan-per-tuple optimizing of database queries with user-defined functions ,(1998)
James Lee Showalter, Jeffrey M. Collins, Method and apparatus for managing metadata associated with entities in a computing system ,(2008)
David S. Rubin, Brijesh Agarwal, Database system with methods for optimizing query performance with a buffer manager ,(1995)
Berthold Reinwald, Mir Hamid Pirahesh, Saileshwar Krishnamurthy, Mehmet Altinel, Chandrasekaran Mohan, Christof Bomhoevd, System and method for adaptive database caching ,(2008)
Bruce McCready, Hanuma Kodavalla, Ashok Madhukar Joshi, Sumanta Chatterjee, Database system with methods for appending data records by partitioning an object into multiple page chains ,(1995)
Joseph B. Elad, Jonathan Dale, Bin Yu, Apperson Hunter Johnson, Srikanth V. Kallurkar, Collaboration portal (COPO) a scaleable method, system, and apparatus for providing computer-accessible benefits to communities of users ,(2008)