http://goo.gl/EmKxy0

Home > ASE > Statement Cache and SQL Query Plan

Statement Cache and SQL Query Plan

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:
  1. No comments yet.
  1. No trackbacks yet.