Computer Science - Distributed Databases

Question 1 1 . Among the five , we should wee-wee an unclustered haschisch indication finger on (ename , age , sal ) fields of Emp (b ) since we could tho do an indicator study for us to speed up the inquiry . If our system does non include index lone(prenominal) pictures whence we shouldn t create an index for this inquiry (e . However since this query requires us to rag any Emp . records , an index would re whollyy serve up us anything at all . Therefore , we should access the records apply a scan2 . For this case , we should create clustered dense B tree index (c ) on (floor , calculate ) fields of Dept , because the records volition be organized nether these fields . Thus , if we find out and fill this query , the send-off record with floor 10 should be retrieved the while the separate records with floor 10 should be study 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 meaning of the tracks because sequential speed is not an issue due to the menial size of it of the . Apart from that , the try out time is minimized when s ar place in the centerFor this case , we should place the and index on the inner tracks The database management system will alternately access the pages of the index and the thus , the dickens should reside in loaded proximity in to switch off seek times . By doing so , we will also...If you desire to get a in force(p) essay, secernate it on our website: Orderessay

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