Question: Consider these relations: Emp ( eid: integer, ename: string, sal: integer, age: integer, did: integer ) Dept ( did: integer, budget: integer, floor: integer, mgr
Consider these relations:
Empeid: integer, ename: string, sal: integer, age: integer, did: integer
Deptdid: integer, budget: integer, floor: integer, mgr eid: integer
Salaries range from $ to $ ages vary from to
which of the listed index choices would you choose to speed up the query?
Query: Print ename, age, and sal for all employees.
Group of answer choices
Clustered B tree index on fields of Emp.
Clustered hash index on fields of Emp.
Unclustered Btree index on fields of Emp.
Unclustered hash index on fields of Emp.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
