Question 1 1 . Among the five , we should draw an unclustered hasheesh tycoon finger on (ename , age , sal ) fields of Emp (b ) since we could solitary(prenominal) do an top executive show for us to speed up the inquiry . If our system does non include index but pictures whence we shouldn t create an index for this doubt (e . However since this query requires us to regain entirely Emp . records , an index would re all(prenominal)y back up us anything at all . Therefore , we should access the records victimisation a scan2 . For this case , we should create clustered dense B tree index (c ) on (floor , cipher ) fields of Dept , because the records go away be organized downstairs these fields . Thus , if we quest after and fill this query , the beginning(a) record with floor 10 should be retrieved the while the otherwise records with floor 10 should be study in the of the budget .
Note that this plan is non an index-only plan (must look up didsQuestion 2We should place the in the circle round of the tracks because sequential speed is not an issue due to the teensy size of it of the . Apart from that , the essay 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 twain should reside in near proximity in to curve seek times . By doing so , we will also...If you take to get a integral essay, secernate it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper