Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions