Suppose both queries (e) and (f) from the previous exercise need to be supported. What indices should be chosen for Teaching and Course?
What will be an ideal response?
A clustered index on Semester supports (f). It can also be used to support (e) (although it does not do the job as well as a clustered index on CrsCode). Use this solution if (f ) is the more important query. If (e) is more important, use a clustered index on CrsCode of Teaching to evaluate (e); the DBMS can use an index-nested loop join (using the index on CrsCode in Course and scanning Teaching in the
outer loop) to do (f). Recall that CrsCode is the primary key in Course so Course will have an index on CrsCode to support such a join.
You might also like to view...
A practical application of the stack data type is
A) the storage of local variables in a function call. B) the tracking of the order of entry into and exit from nested loops. C) the tracking of the order of calls and returns of functions in a program. D) All of the above E) None of the above
_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.
A. Frames B. Cells C. Divs D. Tables
________ is a set of analytical tools to use to apply formatting, create charts, and insert basic functions
Fill in the blank(s) with correct word
If you delete a file from removable media, it is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin.
Answer the following statement true (T) or false (F)