Oracle 12c Optimizer enhancements
Introduction
Optimizer is the key driver component in the execution of SQL query in Oracle database. The optimizer functions with objects’ statistics, selectivity and cardinality to calculate the cost of data fetch operation and ultimately…