Chapter 11 Review Questions 1. It is a process that is done locally on a client. The performance tuning will send a query to the server and come back with an answer in a certain amount of time with the little resources being used on the server side.

2. This process is being done on the server with the DBMS. The best way to this is to see how long a response takes from a client machine to the DBMS. The faster the response the better.

3. Performance tuning would mostly be focusing on input/output (I/O). Measuring the performance of how fast data is moved through the disks on the server. You don’t want the server to always use I/O instead they are going to want the data cashed because it doesn’t have to search the disks to retrieve the data.

4. Database statistics are measurements from the DBMS. They usually look at tables, columns and indexes that are being used. By measuring those that can see the performance of the system and make critical decisions to make the system better.

5. There are many different programs out there that can measure database statistics. Some commands that are built in the system to obtain the stats are to use to ANALYZE command.

6. Most measurement that are typical are the number of disk blocks being utilized, also the number of rows and how long the length of the rows are. Also including the smallest value within each column, including column that also are utilizing indexes.

7. They are two different command that do two different outputs. A DML statement manipulates the data. But a DDL updates the data directory and the system catalog.

8. Here are the 3 phases:

* Parsing –this step parses the SQL query and uses the most efficient way to execute it. * Execution- this step executes a SQL query. * Fetching – this grabs the data and send the output back to the client requesting the data