1 / 1

Study Group exercises (3/19 and 3/20)

Study Group exercises (3/19 and 3/20) 1. Consider the Book DB table, assertion, and sample query definitions accompanying this handout. Read through the slide deck ViewsWithBlankShipperView.pptx . On page 5, define a view that is required by a person (or process)

millie
Download Presentation

Study Group exercises (3/19 and 3/20)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Study Group exercises (3/19 and 3/20) 1. Consider the Book DB table, assertion, and sample query definitions accompanying this handout. Read through the slide deck ViewsWithBlankShipperView.pptx. On page 5, define a view that is required by a person (or process) responsible to “shipping” books that are ready to be shipped. That is, the books have been paid for [PaymentClearanceDate is not null], the books have not been shipped yet [ShipDate is null], and there are enough copies in stock of the book to satisfy the order b) For each of the three queries listed at the end of the Book DB file, give candidate indexes that you think would speed up the query’s evaluation, if the indexes were implemented with the DB. For each index that you suggest, state whether you think the query would benefit most from a balanced tree index or a hash index, or either would give about the same benefit (and REMEMBER, that an index will almost never be chosen to benefit a single query).

More Related