Build a database for the scenario in Exercise 11.5 using the DBMS of your choice. Use the EXPLAIN PLAN statement (or an equivalent provided by your DBMS) to compare the best plan that you found manually with the plan actually generated by the DBMS.

What will be an ideal response?


This is a hands-on exercise where the students are invited to experiment with the EXPLAIN PLAN statement or the visual tuning tools provides by some DBMS vendors.

Computer Science & Information Technology

You might also like to view...

A(n) ____ restricts data in a single table to create a temporary subset of records.

A. datasheet B. filter C. operator D. expression

Computer Science & Information Technology

What does the notation Myriad Pro Semibold Condensed 12/15 × 30 mean?

What will be an ideal response?

Computer Science & Information Technology

Configure SW2 to be the spanning tree root bridge.


What will be an ideal response?

Computer Science & Information Technology

What is a microbenchmark?

a) a real program, whose executions on various systems are evaluated to make comparisons between systems b) a small program or function that measures the time required for a system to perform a specific operating system primitive or system operation c) a program that is designed to evaluate the performance of a specific component or subsystem, such as the file system d) a measure of "raw horsepower," used for making quick comparisons between hardware

Computer Science & Information Technology