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

Home -> Community -> Usenet -> c.d.o.server -> Re: Clustering Indeces

Re: Clustering Indeces

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/04
Message-ID: <3395ad97.44052883@www.sigov.si>#1/1

On Wed, 04 Jun 1997 09:10:20 -0600, JP Soria <jpsoria_at_saxe.com> wrote:

>We have a table that contains 48 months of data. The table has approx.
>149 million rows. We are not using the partition view, as we understand
>there are some problems when running with parallel query. (yes, no?)
>The datawarehouse is set up as a standard star schema, q: How do we set
>up the primary index to index only the first 100,000 records then the
>next and so on, and then cluster the indeces? Any response is greatly
>appreciated.
>--
>JP Soria
>Jr. Oracle7 DBA
>Email: jpsoria_at_saxe.com
>"Failing to plan = planning to fail"

AFAIK you can not do this in Oracle7. You can not index only a part of table's rows.

I don't know about problems with PQ on partition views but have been told that partitioned tables in Oracle8 are much much better and much more useful. In fact they are one of the main new features of Oracle8 if we put it's object oriented features aside.

Regards,


Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3
e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000
Received on Wed Jun 04 1997 - 00:00:00 CDT

Original text of this message

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