Re: doubt on order of table scan

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 16 Oct 2005 12:42:08 +0200
Message-ID: <0hb4l1ppmcms5son1iomcd40cuobnbvvg0@4ax.com>

On Sun, 16 Oct 2005 11:57:10 +0200, "News" <news_connection_at_yahoo.fr> wrote:

>"DA Morgan" <damorgan_at_psoug.org> wrote in message
>news:1129418200.7123_at_yasure...
>> News wrote:
>> In this case your use of the phrase "clustered index" indicates that you
>> have not read the Oracle docs.
>
>I know there are only 2 types of index in Oracle: b-tree and bitmap and what
>"Clustered Tables" means but could you tell me if each block in Oracle
>points to the next and previous blocks ? If so then the internal mechanisms
>are the same.
>

You forget index compression, reverse key indexes, and index organized tables.

Blocks do not point to each other in Oracle.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Oct 16 2005 - 05:42:08 CDT