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"
Received on Wed Jun 04 1997 - 00:00:00 CDT
