Oracle Partitions.
What is partition purning .
How can we optimize partition table perfomance when performing DML operation .
How can we optimize partition table perfomance when performing DML operation .
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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('2016
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
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('2016
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial