5. To optimize the performance of this database, what are the indexes you are recommending for these tables. Remember that sparsity will help drive you index selections. Answer the following: Textbook Reference: Page 497-500

1. Name the top 3 low data sparsity and explain why

2. Describe & explain at least two potential SQL indexes to improve performance

Create a comparison access plan & I/O cost table and the indexes to fill in the values below

CREATE INDEX EMP_NDX1 ON .

CREATE INDEX EMP_NDX2 ON

Use the following assumptions:

a. There are 750 employees.

b. There are 150 male employees.

c. There are 50 employees in department #100.

d. There are 15 male employees in department #100.

Plan Step Operation I/O Operations I/O Cost Resulting Set Rows Total I/O Cost Al A SO:IT Operation BB1 BB2 B B B3 B4 SORT Operation