Choose indexes(3)

• Guidelines: F(C).7,18(17).3(pp.509)

• remove indexes

• if insert will increase 10% size of table, drop the indexes temporarily

• Homework:

• design a program to test the performance of each index file type and file type of selected DBMS.
• create views for your database
• prepare an environment for your APs.