Estimate the I/O cost of retrieving records from Parts table that contains price less than or equal 1000 rupees. Assume that 15% of tuples satisfy the selection criteria.?

Estimate the I/O cost of retrieving records from Parts table that contains price less than or equal 1000 rupees. Assume that 15% of tuples satisfy the selection criteria. There are 3300 pages in the Parts table, with 50 records each page. The clustered B+ tree index on price attribute is the only index available in the Parts table. This index takes up 1/3 of the table's space. 

0 Answer
0 Answer
No answer yet, be the first one to answer this question.
Async Other Related Discussions
database management system
Practice Mock Test
database management system
Take Mock Testforward arrow