Hi, I will explain What is the Oracle Optimizer and How Cost-Based Optimizer Works in this article. You can read the following article before this. Performance Tuning Features and Tools in Oracle | Oracle Database Performance Tuning Tutorial -2       Oracle database has optimizer that determines which execution plan is most efficient and best … Continue reading What is the Oracle Optimizer and How Cost-Based Optimizer Works ? | Oracle Database Performance Tuning Tutorial -3