Re: table storage

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/03
Message-ID: <38bfb69e.3061267@news.demon.nl>#1/1

On 3 Mar 2000 07:10:39 GMT, feigenb_at_is03.fas.harvard.edu (Lee) wrote:

>Hi everyone,
>
>I'm new to Oracle, having used SQL Server and mysql in the past, and having
>browsed the idnex of a couple of books, I have been unable to find the answer
>to the following question:
>
>Using Oracle, is there a way to specify a column (or columns) that a table
>should be physically sorted by? (i.e., is there a way to specify one or more
>columns such that the data is stored on disk in the order of values in that
>column(s))?
>
>I believe this is accomplished in SQL*Server via the use of a CLUSTERED INDEX,
>but this seems to be a SQL*Server specific thing...
>
>Any pointers?
>
>Lee

Create a cluster
create an index on that cluster
and create the table in that cluster.
This option is seldom used, as there seem to be performance drawbacks It is usually discussed in the context of 2 interrelated tables with a master detail relationship, which are always needed simultaneously.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 03 2000 - 00:00:00 CST