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. 

• Asram
• 1550 दृश्य
• 0 उत्तर

• What is DBMS and Rdbms with example?
• What are the four major types of DBMS?
• What is an example of a database? Explain your answer
• What are the two main types of databases?
• Every person have based knowledge of Database Management System?
• What do you mean by database explain? Explain your answer
• What is the purpose of database management system?
• What are the advantages of DBMS?
• What is DBMS and types of DBMS? Explain your answer
• What Legal Advice Should I Seek?