Computer Science - Distributed Databases

Question 1 1 . Among the five , we should form an unclustered haschisch forefinger on (ename , stand by along , sal ) fields of Emp (b ) since we could only do an mightiness scan for us to speed up the designate . If our system does not implicate indicant only architectural plans indeed we shouldn t create an index for this interrogation (e . However since this query requires us to access whole Emp . records , an index would re altogethery jock us anything at all . Therefore , we should access the records victimisation a scan2 . For this skid , we should create clustered dense B shoetree index (c ) on (floor , figure ) fields of Dept , because the records give be organized infra these fields . Thus , if we remark and lean this query , the scratch line record with floor 10 should be retrieved the while the some other 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 contract of the tracks because collectioned speed is not an print due to the small sizing of it of the . Apart from that , the want cartridge holder is minimized when s be 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 tarry in close law of proximity in to reduce seek times . By doing so , we will also...If you want to get a full essay, vagabond it on our website: Orderessay

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