Statement Cache and SQL Query Plan

Home > ASE > Statement Cache and SQL Query Plan

Statement Cache and SQL Query Plan

April 26th, 2012 Anurag Dubey Leave a comment Go to comments

As procedure cache stored the query plan of stored procedures similarly statement cache saves SQL text and SQL query plan previously generated for ad hoc SQL statements, enables ASE to avoid recompiling incoming SQL that matches a previously cached statement.

Basically Statement Cache is a part of Procedure Cache, when enabled the statement cache reserves a portion of procedure cache.

Check the Sybase Wiki @ sybasewiki.com

Categories: ASE Tags:

Contributors

Anurag has more than 6+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms.

AnVa (Founder) has more than 6+ years Exp in Sybase ASE/REP Database Administration. His area of interest is ASE Implemenation and maintenance , Performace Tunning , Sybase HA ,Shared Cluster and Replication. Also exploring the In-Memory Databases (HANA) , Big Data, Hadoop and Java. He is also supporting the Forum Sybase Team and started this sybaseblog.com in late 2009.

Andrew is Guest Blogger on sybaseblog.com. Andrew have been working with Sybase for more than a decade: ASE & RS mostly. He has written lot of tools that help to manage/monitor the system for ASE and Replication and some tools are on the way.. He is also poet and love to be creative all the way.

SAP Sybase Blog