Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index optimizing on Oracle

Re: Index optimizing on Oracle

From: Sheilah Scheurich <scheuric__at__sprynet_.com>
Date: 1997/09/29
Message-ID: <342FF473.4DA7@_sprynet_.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US