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:
Emp(eid: integer, ename: string, sal: integer, age: integer, did: integer)
Dept(did: integer, budget: integer, floor: integer, mgr eid: integer)
Salaries range from $10,000 to $100,000, ages vary from 20 to 80.
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 B+tree 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!