12.7. Review Questions
What GUI tool analyzes a SQL statement and identifies the steps used to process the query?
The two general categories of indexes are ________ indexes and _________ indexes.
Which type of index is best for columns with a low cardinality?
Which dynamic performance view can assist the DBA in sizing the buffer cache appropriately?
Which type of table divides the contents of a very large table into more manageable chunks, both improving the manageability of the table for the DBA and potentially increasing the performance of queries on the table?
Which data dictionary views contain information about table indexes and the table columns indexed?
Name the six steps in Oracle's Tuning Methodology in order of priority.
Which feature associated ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
