32.2k views
4 votes
What is the name of the special internal database where the query optimizer finds information?

User Mechkov
by
7.8k points

1 Answer

3 votes
The relational catalog is the description of the data base and its subjects. Commonly, this information is stored in the data base or in another table - possibly with a reserved name and is not directly updated by user applications. An alternative word for relational catalog is "system catalog" or occasionally called "data dictionary". Examples of entities contain:

- Databases

- Tables

- Logs

- Variables

- Columns

- Constraints

- Users
User Manoj Menon
by
9.4k points