Database Reference
In-Depth Information
Assume that there are 100,000 tuples in the
Sales
fact table, 2,000 in
Customer
, 30,000 in
Product
, 500 in
Time
, and 1,000 in
Employee
.The
Northwind database is stored in a column-store database system. Each
disk block has a size of 1MB. You can assume all data you consider
necessary to answer the following questions:
How many disk access will take the evaluation of the query above?
Assume a row-oriented database, with a block size of 32K. What
would be the answer to the previous question?
Search WWH ::
Custom Search