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 when Adaptive Server has to retrieve index, object, or database information at run time.
For more information on configuring metadata caches, see “Metadata Caches” on page 11-61 in the System Administration Guide.
