Midterm 3 Solutions 12

8 throughout your experience at puppy love you have

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: including touchdowns scored, personal weightlifting record, ORDER BY weight DESC favorite flower, etc. However, he didn’t care about those details. All LIMIT 10; he wanted to do was to see the top 10 players by weight. Essentially he wanted to run the query to the right. 6 Which of the following optimizations could reduce the cost of executing that query while still returning the correct answer? On the answer sheet (not here!) mark the squares by the letters for all correct answers. (Zero, one, or more than one may be correct.) [2pt] ▢ ▢ ▢ ▢ a. Use Tournament Sort instead of Quicksort. b. Project to (name,weight) during scan. c. Use Hybrid Hashing. d. Replace Rendezvous steps with Streaming. a, b. (c) wouldn’t help because hashing doesn’t help with ORDER BY. (d) doesn’t...
View Full Document

This note was uploaded on 01/24/2014 for the course CS 186 taught by Professor Staff during the Fall '08 term at Berkeley.

Ask a homework question - tutors are online