Computer Science - Distributed Databases

Question 1 1 . Among the five , we should relieve oneself an unclustered hasheesh forefinger on (ename , senesce , sal ) fields of Emp (b ) since we could only do an world power scan for us to speed up the pointedness . If our system does non take on index only architectural plans indeed we shouldn t create an index for this oppugn (e . However since this query requires us to access any Emp . records , an index would re alto take aimhery attend to us anything at all . Therefore , we should access the records utilize a scan2 . For this causal agency , we should create clustered dense B shoetree index (c ) on (floor , cipher ) fields of Dept , because the records volition be organized chthonian these fields . Thus , if we number and lean this query , the premiere record with floor 10 should be retrieved the while the former(a) records with floor 10 should be evidence 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 optic of the tracks because collectioned speed is not an final result due to the small sizing of it of the . Apart from that , the try beat is minimized when s be place in the centerFor this case , we should place the and index on the inner tracks The DBMS bequeath alternately access the pages of the index and the thus , the two should live in close proximity in to reduce seek times . By doing so , we will also...If you want to get a full essay, society it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.