Hi everyone,

I am working on the following problem.

You are running a DBMS on a computer which has 3 kByte disk block
size. Reminder: 1kByte=1024bytes, 1 MByte = 1024 kBytes .

Table T in your database D has size 200MBytes. You execute a query:
"select * from T".
How much data will be read from the drive? Assume that n*size_of_tuple
= block_size, where n is natural.

I would appreciate it if somebody could give me a hand with that
problem.

On 2011-11-17, elodie <elodie.gillain (AT) gmail (DOT) com> wrote:
It depends on the plan the database decides to use to fetch the rows.
hopefully no more than 204801KB


--
⚂⚃ 100% natural

--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---