Computer Science - Distributed Databases

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

Note that this innovation is not an index-only plan (must look up didsQuestion 2We should place the in the center of the tracks because consecutive speed is not an issue due to the small surface of the . Apart from that , the seek time is minimized when s argon 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 propinquity in to reduce seek times . By doing so , we will also...If you want to get a full essay, view it on our website: BestEssay Cheap.com

If you want to get a ! full essay, visit our page: cheap essay