Articles
Week 8: Articles
The articles for this week focus on learning how to use the data dictionary, the query dictionary, and write query diagnostics. The data dictionary contains all the information about data types and structures in the database. The query dictionary is a memory area where all the current SQL statements are stored after they are parsed, which prevents re-parsing frequently used queries. Diagnostics queries look up data stored in the data or query dictionaries.
Articles