Vladimir Begun wrote:
> Full scan
> This is available if a predicate references one of the columns in the
> index. The predicate does not need to be an index driver. Full scan
> is also available when there is no predicate, if all of the columns
> in the table referenced in the query are included in the index and at
> least one of the index columns is not null. Full scan can be used to
> eliminate a sort operation. It reads the blocks singly.
To avoid any confusion 'singly' here means "logically singly' -- in the
reality (modern versions) it looks more like scattered read. Also this
'singly' depends on session settings.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: vladimir.begun_at_oracle.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Oct 24 2003 - 00:59:26 CDT
