Re: Index optimizing on Oracle

Chris Phillips wrote:
>
> Hello again,
>
> I am currently working on a project to port our product from SQL Server to
> the Oracle database. One of the major differences I have run into is
> clustered indexing. In SQL Server clustered indexing means that the table
> is physically ordered in the order the index is specified as. This helps
> in the retrieval of data if you are retrieveing the data sequentially. It
> appears that clustering is not the same on Oracle. What methods can I use
> to increase index preformance in this kind of situation.
>
> Thanks in advance,
>
> Chris
> cphillip_at_mindspring.comYou can try loading the data into the table presorted and then creating
the index with the nosort option. This will help achieve the same thing you had before.

-Sheilah Scheurich
DBA
to respond via email remove the underscores. Received on Mon Sep 29 1997 - 00:00:00 CDT