Oracle Partitions.

MIHIR KAR
MIHIR KAR used Ask the Experts™
on
What is partition purning .

 How can we optimize partition table perfomance  when performing DML operation .
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Engineer
Top Expert 2016
Commented:
Prune ( meaning ) :

Tu reduce or trim by removing unwanted parts.

To explain at a very basic level,
Consider, there is a table with a 1 year data partitioned on "some date column for example created_date"  on monthly basis

select * from table where created_date=to_date('20160510','yyyymmdd');  -- 10th of May

In given scenario, optimizer will prune the table and search only in "May" partition.
Had the table been not partitioned, entire data would have been scanned thus 12 times the scanning.

To read how partitioning works, please refer metanote :

https://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial