Oracle Partition Help

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 22 Feb 2005 10:05:30 -0800 (PST)
Message-ID: <20050222180530.43852.qmail@web51305.mail.yahoo.com>

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  

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

Received on Tue Feb 22 2005 - 13:08:29 CST