Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Clustering Indeces
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 3e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000
![]() |
![]() |