Re: Learn Oracle in three days?

From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 13 May 2002 10:58:04 -0600
Message-ID: <3cdff041$1_12@news.teranews.com>

"tojo" <TomJordanTojo_at_hotmail.com> wrote in message news:MPG.174a0d529f8b4b6c98968d_at_news.t-online.de...
> In article <3CDFEAF2.653BBB97_at_exesolutions.com>,
> dmorgan_at_exesolutions.com says...
> > Pablo Sanchez wrote:
> >
>
> I think he means IOT's, or selecting columns that are 'covered' by
an
> index.

Nothing as fancy as an index-organized table. The optimizer (now! <g>) is clever enough to do the latter as you state: pull its values from the index when it doesn't need to reach the base table.

Thx!i Received on Mon May 13 2002 - 11:58:04 CDT