Re: Problems with SELECT *

From: Cimarron Taylor <cimarron+google_at_taylors.org>
Date: 13 Mar 2003 10:09:37 -0800
Message-ID: <29e28c51.0303131009.10514345_at_posting.google.com>


> 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 - 19:09:37 CET

Original text of this message