RE: Oracle Partition Help

  • From: "Mohan, Ross" <RMohan@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 22 Feb 2005 18:37:37 -0000

you'll get the max partitioning bennies if you "ask" for them, by =
partition-pruning (to the extent possible, natch) in your SQL. Try to =
find some semantically-relevant way of getting "....WHERE COL1=3D...." =
in your query and you'll be good.=20

If you can't partition-prune, brace yourself for potentially brutal =
global scans, and you=20
might want to keep your part/global tab/idx stats up to snuff.=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
Sent: Tuesday, February 22, 2005 1:06 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle Partition Help


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=20
select * from table1 where col1=3D12345;

Is there advantage I will get on the above query which
is partitioned but not with Col1.=20
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.


Do you Yahoo!?=20
The all-new My Yahoo! - Get yours free!=20


Other related posts: