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: Gianluca Hotz <ghotz_at_alphasys.it>
Date: Fri, 14 Mar 2003 14:12:51 +0100
Message-ID: <b4skjr$237et0$1@ID-184953.news.dfncis.de>


"Cimarron Taylor" <cimarron+google_at_taylors.org> wrote in message news: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.

Another thing is that some system, provided there's an index, may "cover" the query fetching densely populated index pages instead of fetching the data pages.

Gianluca Hotz. Received on Fri Mar 14 2003 - 07:12:51 CST

Original text of this message

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