Question 1 1 . Among the five , we should create an unclustered hasheesh indicant finger on (ename , age , sal ) fields of Emp (b ) since we could besides do an index scan for us to speed up the inquiry . If our system does not include index scarcely pictures whence we shouldn t create an index for this oppugn (e . However since this query requires us to entry all Emp . records , an index would really attention us anything at all . Therefore , we should access the records victimisation a scan2 . For this case , we should create clustered dense B tree index (c ) on (floor , budget ) fields of Dept , because the records leave alone be organized under these fields . Thus , if we make out and fill this query , the first record with floor 10 should be retrieved the while the other records with floor 10 should be study in the of the budget .
Note that this plan is not an index-only plan (must look up didsQuestion 2We should place the in the contract of the tracks because sequential speed is not an issue due to the handsome size of it of the . Apart from that , the seek time is minimized when s ar place in the centerFor this case , we should place the and index on the inner tracks The DBMS will alternately access the pages of the index and the thus , the two should reside in dummy up proximity in to reduce seek times . By doing so , we will also...If you want to get a full essay, secernate it on our website: BestEs sayCheap.com
If you want to get! a full essay, visit our page: cheap essay
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.