Oracle Partition Help

From: Sanjay Mishra <smishra_97@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 22 Feb 2005 10:05:30 -0800 (PST)

Hi

I am running a query against Oracle Table which is
partition locally. All index are also partition
locally and I had index on table1 column name COl1.
Table is partition by  ID,dateofBirth column

Now when I running 
select * from table1 where col1=12345;

Is there advantage I will get on the above query which
is partitioned but not with Col1. 
Is there any disadvantage of using partition in this
case. The requirement for partition is to delete data
when it is more that 1 yr old and each month partition
can have 10-20G data.

thanks
Sanjay


                
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com 
 

--
//www.freelists.org/webpage/oracle-l

References:
- ANy thought for Locking issue on the following code
  - From: Sanjay Mishra

Oracle Partition Help

Other related posts: