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.
- 1412 Views
- 0 Answers
0 Answers
- What are the four major types of DBMS?
- What is the purpose of database management system?
- Answer this question with explanation
- What is difference between database and DBMS?
- Answer this and explain your answer
- What are the advantages of DBMS?
- Can someone please let me know about the dates of Database Management System Exam?
- What is relationship in database and its types?
- What is DBMS and Rdbms with example?
- What is DBMS and types of DBMS? Explain your answer
Practice Mock Test
database management system