table_definition_cache is used to set the number of cached table definition objects. The table definition cache stores metadata (such as column names and data types) of the tables in the database so that this information can be quickly accessed during query execution. When this limit is reached, the system disables the least recently used table definitions based on the least recently used (LRU) algorithm to free up space for new table definitions.table_open_cache for the table_definition_cache parameter.Required | Description |
Parameter Type | ULONG |
Default Value | 4294967295 |
Value Range | 400 ~ 4294967295 |
Effective Scope | GLOBAL |
Restart Required | No |
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback