Northeastern University Hash Indexes to Investigate Performance Paper

Activity 11 – Hash Scans

Using sqlda, complete Activity 11 in the text. Submit a Word document with the answers to Step 6 and 8,. Include screenshots of the successful output. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

Exercise 28 – Comparing Hash Indexes

Using sqlda. complete Exercise 28 in the text. Submit a Word document with the output from your queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

Activity 12 – Implementing Hash Indexes

Using sqlda, complete Activity 12 in the text. Submit a Word document with answers to the questions and screenshots of the output of your queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

Exercise 29 – Inner Joins

Attached Files:

• smalljoins.dump (2.068 KB)
• smalljoins.sql (1.961 KB)

Submit a Word document with the answers to the questions and screenshots of the output of your queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.