Re: Partitioning Questions

when u do partioning at least when one partition fails then u can still select from the remaining partition. my .02 c worth.

-----Original Message-----
From: Terrian, Thomas <Thomas.Terrian_at_standardregister.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tuesday, June 06, 2000 3:32 AM
Subject: Partitioning Questions

>We are just now beginning to work with partitioned tables and views. I
have
>a few nagging questions. One of them is -- What is the true performance
>benefits of partitioning? I am not talking about the maintenance benefits,
>just the query performance benefits.
>
>For example, since our queries will be using the indexes, no reason to
>partition the table right? I guess there would be some benefit on
>partitioning the table so that multiple disk drives could be working to
>retrieve the data. Any other performance benefits (not including the DDL
>benefits)?
>
>And what about the index partitioning that we are going to do. It kind of
>seems like we are doing Oracle's work for them. I mean, we are telling the
>optimizer that this partition has these values, this other partition has
>these other values, etc. Is this not just a leaf block in a b-tree index
or
>am I missing something? Why would this help the optimizer?
>
>Ok, you can blast away. I am sure that I am missing something obvious and
>maybe someone can explain it to me. What are the true performance benefits
>of table and index partitioning? (again, not the DDL benefits).
>
>Tom
>
>Tom Terrian
>Oracle DBA
>(937) 221-1647
>Thomas.Terrian_at_standardregister.com
Received on Wed Jun 07 2000 - 05:10:50 CDT