Computer Science - Distributed Databases

Question 1 1 . Among the five , we should create an unclustered hash list on (ename , age , sal ) fields of Emp (b ) since we could only do an index scan for us to speed up the interview . If our system does not include index only externalises and then we shouldn t create an index for this query (e . However since this query requires us to access all Emp . records , an index would really help us anything at all . Therefore , we should access the records using a scan2 . For this case , we should create clustered dense B tree index (c ) on (floor , budget ) fields of Dept , because the records will be organized under these fields . Thus , if we follow and move this query , the first record with floor 10 should be retrieved the while the other records with floor 10 should be rent 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 center of the tracks because resultant speed is not an issue due to the small sizing of the . Apart from that , the seek time is minimized when s are 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 close proximity in to reduce seek times . By doing so , we will also...If you want to get a full essay, suppose it on our website: Orderessay

If you want to get a full essay, wisit our page: write my essay .