| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitioning Questions
Tom,
Here are a few links that should help answer your questions.
http://www.oracle.com/oramag/oracle/99-Mar/29or8.html
http://technet.oracle.com/doc/server.815/a67781/c09parti.htm
http://www.oracle.com/openworld/white_papers/127.pdf
HTH
> -----Original Message-----
> From: Terrian, Thomas [SMTP:Thomas.Terrian_at_standardregister.com]
> Sent: Monday, June 05, 2000 3:25 PM
> To: Multiple recipients of list ORACLE-L
> 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 << File: ATT13161.ATT >>
Received on Mon Jun 05 2000 - 14:44:20 CDT
 |
 |