Partition Pruning with Example

In previous article we saw the benefits of partition pruning. Partition Pruning in Oracle Here we will see how partition pruning takes place when you run the query accessing your partitioned table. For instance , you have transaction table from year 2011 to 2019 with different partition for each year.  And you want statement of […]

Read More

Partition Pruning in Oracle

Pruning itself means to cut the dead parts and work on the pieces which are indeed important one. In Oracle partition pruning works in the same manner. Oracle can recognize which partitions and sub-partitions need to be eliminated and which partitions should be accessed for the query to be processed. When you have created some […]

Read More