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
  • 29 जनवरी
  • 0 उत्तर
0 उत्तर
0 Answer
No answer yet, be the first one to answer this question.
Async अन्य संबंधित चर्चाएं
database management system
मॉक परीक्षण अभ्यास के लिए
database management system
मॉक टेस्ट ले forward arrow