Hi Can someone help me with question 9.20 please? 9.17 A particular table in a r

Question

Hi

Can someone help me with question 9.20 please?

9.17 A particular table in a relational database contains 100,000 rows, each of which requires 200 bytes of memory. A SELECT statement returns all rows in the table that satisfy an equality search on an attribute. Estimate the time in milliseconds to complete the query when each of the following indices on that attribute is used. Make realistic estimates for page size, disk access time, and so forth.

9.20 Estimate the amount of space required to store the B+ tree of Exercise 9.17 and compare that with the space required to store the table.

Thank you

Explanation / Answer

so u have asked 2 questions in a post which is against cramster rules post single question at a time thanks

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects