Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose that we have a Customers table that has 1000 pages, 100000 tuples, and has a clustered hash index on Customer_ID (primary key). Assume that
Suppose that we have a Customers table that has 1000 pages, 100000 tuples, and has a clustered hash index on Customer_ID (primary key). Assume that each hash bucket is not overflow. If we have a query with the following selection: WHERE Customer_ID = 5000, what is the cost (in term of number of disk I/O's) to retrieve the tuple that satisfies the selection condition using the available clustered hash index?
a. 1000 disk I/O's b. Two disk I/O's c. One disk I/O d. 5000 disk I/O's e. Three disk I/O's
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started