Optimization

Question 1

Database Performance Tuning

Answer 1

Activities and procedures that reduce response time of the database system. Performance dictated by CPU processing power, available RAM (primary memory), and input/output (hard disk and network) throughput.

Question 2

SQL Performance Tuning

Answer 2

Query that returns the correct answer in the least amount of time, using minimum server resources.

Question 3

I/O

Answer 3

Input/Output Request

Low-level data access operation that reads/writes data to and from computer devices.

Question 4

Fully Equivalent

Answer 4

Optimized query results are always the same as the original query

Question 5

Access Plan

Answer 5

Result of parsing. Contains a series of steps DBMS will use to execute query and return results.

Question 6

Query Processing Bottleneck

Answer 6

Delay introduced in the processing of an I/O operation that causes the overall system to slow down.

Question 7

Data Sparsity

Answer 7

Number of different values a column can have. Low sparsity makes an index less necessary.