CS634 – Homework 2
Released Feb 8, Due Mon., Feb. 22
Intro to Indexes
Instructions: The homework is due BEFORE CLASS on the duedate. Please hand in paper copies (either typeset or hand-written copies are fine, as long as the hand writing is clear).
Note that some of these are solved online in the student answer set.
Problem 1 Using Indexes for simple queries. Best to do this
early to have Oracle to yourself when timing. Check for other use
by using the "uptime" command. Here is what it looks like when dbs2 is
idle: the last three numbers are measures of system load currently, over
the last minute, the last 5 minutes, and the last 15 minutes. They
should be under 0.1 when you start to do measurements.
In Oracle on dbs2, a large table eoneil.bench is public for querying and
large enough to take seconds to scan.
2:36pm up 83 day(s), 16:23, 2 users, load average: 0.00, 0.02, 0.03
Exercise 8.4 in the textbook. Ignore the "order of entries" question, since it seems unclear. Show the first data entry and the last. Use RIDs (1,1), (1,2), (1,3), (2,1), and so on.
Exercise 8.10 in the textbook
Exercise 9.5 in the textbook
Exercise 9.6 in the textbook.
Exercise 10.2 in the textbook (only questions 1-5).
Exercise 10.8 in the textbook.