Metadata cache management

Adaptive Server allows you to manage individual metadata caches for:

• User indexes
• Objects such as procedures, triggers, views, rules, and defaults
• Databases

Managing individual metadata caches for these objects is beneficial for a server
that contains a large number of user indexes and objects and where there is high
concurrency among users.
A metadata cache is a reserved area of memory for tracking information for
indexes, objects, or databases. When you configure a metadata cache for
indexes, objects, or databases, Adaptive Server accesses the information
directly from the in-memory structure that describes them in the sysindexes,
sysobjects, or sysdatabases row.
This method improves performance because Adaptive Server bypasses
expensive calls that require disk access. Configuring metadata caches also
improves performance by reducing synchronization and spinlock contention
...