number of open indexes

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

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.

• Optimizing number of open indexes
  If the default value of number of open indexes is insufficient, SAP ASE displays a message after trying to reuse active index descriptors, and you must adjust this value.