SAP Knowledge Base Article - Preview

2014383 - Impact of DDL on tables bound to cache with dbcc tune (des_bind) - SAP ASE

Symptom

  • High volatile ASE environments require hot tables to remain in cache indefinitely.
  • The hot tables are categorized as des bound tables and the procedure to bind them to cache is by using dbcc tune (des_bind, dbid, objid | objname).
  • What DDL operations are permissible for des bound tables?


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

bind, unbind, create, drop, default, index, table, view, procedure, modify, column, trigger, function, APL, DOL , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.