Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Problems with SELECT *

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@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 - 12:09:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US