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 number scan for us to speed up the reference . If our system does not include index only externalises and thus 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 steer index (c ) on (floor , budget ) fields of Dept , because the records will be organized under these fields . Thus , if we follow and fail this query , the first record with floor 10 should be retrieved the while the other records with floor 10 should be hire in the of the budget .

Note that this curriculum is not an index-only plan (must look up didsQuestion 2We should place the in the center of the tracks because issue speed is not an issue due to the small size 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, mean it on our website: BestEssayCheap.com
If you want to get a full essay, visit ou! r page: cheap essay