If M rows from table-A match the conditions in the query then-08433
If M rows from table-A match the conditions in the query then table-B is accessed M times. Suppose table-B has an index on the join column. If a I/Os are required to read the data block for each scan and b I/Os for each data block then the total cost of accessing table-B is __________ logical I/Os approximately.
This multiple choice question (MCQ) is related to the book/course
vu cs614 Data Warehousing.
It can also be found in
vu cs614 Final Term - Quiz No.2.
If M rows from table-A match the conditions in the query then table-B is accessed M times. Suppose table-B has an index on the join column. If a I/Os are required to read the data block for each scan and b I/Os for each data block then the total cost of accessing table-B is __________ logical I/Os approximately.
(a + b)M
(a - b)M
(a + b + M)
(a * b * M)
