Re: Clusterd index in Oracle

A copy of this was sent to screwbai_at_my-deja.com (if that email address didn't require changing) On Mon, 15 Nov 1999 21:23:37 GMT, you wrote:

>
>
>Is there a concept of clustered index in Oracle (like Sybase)?
>

In Oracle, a cluster is a database object that allows records from >1 table to be stored in the same database block (pre-joined data).

the clustered index in Sybase which basically is "store the whole table" and then "store the whole table again in an index" would be done using an index organized table in Oracle8:

create table foo ( x int primary key, y date ) organization index;

In Oracle8.0, you cannot have any other indexes on this table. In Oracle8i, release 8.1, you may have other indexes on this table.

Using this construct, there is no "table" and "index" -- just the index.

>What determines the order of which records are stored in Oracle?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 16 1999 - 07:33:53 CST