Re: info. on Oracle 8.05 partitioning

I worked on tuning a process that was hitting a table with several million rows.
We tried partitioning, and it made some difference but not much, and in about the same amount of time it would have taken to implement partitioning, we made a process change to the application to get the run time to an acceptable level.
One thing to bear in mind when looking at partitioning - even though it may have been installed with the database, Oracle charges extra for it. Before going down that path, you may want to verify that you already have the license or the budget to buy.
For a book, I used the Oracle Press "Oracle8 Tuning" to get started when I was benchmarking partitioning.

Gopal <gopal_at_typhoon.ocis.temple.edu> wrote in message news:8h6du2$ud5$2_at_cronkite.temple.edu...
>
> I have a 'huge'database in Oralce 8.05. Many of my tables are huge. I
 want
> to try partitioning mainly to improve query performance.
> I would like to get some feedback on how partitioning can improve on query
> performance in a DSS oriented environment. Any info. on how the optimizer
> deals with partitions, local bitmapped indices (both prefixed and
 non-prefixed)
> is welcome.
> I would also like to read up (any non RTFM stuff !) on the topic.
>
> please email me at gopal_rajagopal_at_merck.com.
> Thank you
>
> Regards
> Gopal
>
>
Received on Sat Jun 03 2000 - 00:00:00 CDT