Computer Science - Distributed Databases

Question 1 1 . Among the five , we should create an unclustered haschisch list on (ename , age , sal ) fields of Emp (b ) since we could only do an power scan for us to speed up the audience . If our system does not include index only externalises and hence 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 channelize index (c ) on (floor , budget ) fields of Dept , because the records will be organized under these fields . Thus , if we follow and course this query , the first record with floor 10 should be retrieved the while the other records with floor 10 should be pack in the of the budget .

Note that this envision is not an index-only plan (must look up didsQuestion 2We should place the in the center of the tracks because ending speed is not an issue due to the small sizing 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 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: OrderCustomPaper.com

If you want to get a full essay, visit our p! age: write my paper