Re: Problems with SELECT *

> Databases physically store data in an atomic page of information:
> data page or block. Within the block, as many rows are stored as
> possible. When a SELECT is done, the data page/block is read into the
> 'buffer cache' Whether you do SELECT * or SELECT userid, all the data
> is in the buffer cache.

Not if the system is column-oriented or if the table uses a "Vertical Partitioning" scheme.

Cim Received on Thu Mar 13 2003 - 12:09:37 CST