Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. The relation studentid, name, CGPA, street, city, NID) is given. There is a clustering B+ tree index on name attribute of student relation and
a. The relation studentid, name, CGPA, street, city, NID) is given. There is a clustering B+ tree index on name attribute of student relation and there are 500 unique names. The height of the index is 4 and there are 10 students whose name is Abdullah. The id is a secondary index and height is 5. The record size is 800 bytes and block size is 2KB. Seek time = 10ms, block transfer time = 0.1ms. Find the query cost for the following queries: i. SELECT * FROM student WHERE name = 'Abdullah' ii. SELECT * FROM student WHERE id = 1912020 b. Describe the algorithm for query a (i)
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