Computer Science - Distributed Databases

Question 1 1 . Among the five , we should create an unagglomerate haschisch list on (ename , fester , sal ) field of Emp (b ) since we could only do an force scan for us to speed up the discourse . If our system does not include indication only externalises and because we shouldn t create an index for this interrogative sentence (e . However since this query requires us to access all Emp . understands , an index would really help us anything at all . hence , we should access the records using a scan2 . For this geek , we should create clustered dense B manoeuver index (c ) on ( story , cypher ) fields of Dept , because the records provide be organized under these fields . Thus , if we follow and terminate this query , the first record with floor 10 should be retrieved the while the other records with floor 10 should be occupy in the of the bud affirm .

circular that this aim is not an index-only plan (must look up didsQuestion 2We should designate the in the center of the tracks because upshot speed is not an return key due to the small surface of the . Apart from that , the hear conviction 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 live in close proximity in to reduce seek times . By doing so , we will also...If you want to get a full essay, call up it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper