Exam 11: Database Performance Tuning and Query Optimization

The ____ cache stores the most recently executed SQL statements.

The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.

Describe query optimization and the modes that an optimizer can operate in.

A data file can only contain rows from one single table.

Character field comparisons are faster than numeric,date,and NULL comparisons.

The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

On the client side,the objective is to generate a SQL query that returns the correct answer in the least amount of time,using the minimum amount of resources at the server end.The activities required to achieve that goal are commonly referred to as ____ tuning.

The majority of primary memory resources will be allocated to the ____ cache.

____ is/are the central activity during the parsing phase in query processing.

The system will perform best when its hardware and software resources are ____________________.