Re: Clustering Indeces

From: flange <flange_at_pt.lu>
Date: 1997/06/05
Message-ID: <01bc71ee$9a0c8c40$84d79ac2@LangeFrancois>#1/1

Hi,

        Big_table => 149 millions.

	table_100000_0001 ( 
		key_column data_type 
			constraint table_100000_0001_key_column_nn ,
		row_id	rowid constraint table_100000_0001_rowid_nn ,
		constraint table_100000_0001_pk using index ... storage clause 
	) storage clause ;

	....

	table_100000_1490 ( 
		key_column data_type 
			constraint table_100000_1490_key_column_nn ,
		row_id	rowid constraint table_100000_1490_rowid_nn ,
		constraint table_100000_0001_pk using index ... storage clause 
	) storage clause ;



	fill the 1490 tables whit a pl-sql procedures ( using dbms_sql for the

table name ).

        the query will be now

		select big_table.*
		from big_table , table_100000_n 
		where table_100000_n.key_column = 'value'
		and big_table.rowid = table_100000_n.row_id ;

Francois.
Jurij Modic <jurij.modic_at_mf.sigov.mail.si> wrote in article <3395ad97.44052883_at_www.sigov.si>...
> 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 Thu Jun 05 1997 - 00:00:00 CDT