number of open indexes

number of open indexes sets the maximum number of indexes that can be used simultaneously on SAP ASE.

Summary Information

Default value

500

Range of values

100–2147483647

Status

Dynamic

Display level

Basic

Required role

System administrator

Configuration groups

Memory Use, Meta-Data Caches

If you are planning to make a substantial change, such as loading databases with a large number of indexes from another server, use sp_helpconfig to calculate an estimated metadata cache size. sp_helpconfig displays the amount of memory required for a given number of metadata descriptors, as well as the number of descriptors that can be accommodated by a given amount of memory. An index metadata descriptor represents the state of an index while it is in use or cached between uses.