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 … Continue reading Partition Pruning in Oracle