Hi, I will explain Optimizer Access Paths & Join Operators in this article.     Oracle Join Operators   Read the following article before this, if you want to learn more detail about Optimizer Access paths. Optimizer Access Paths (Table and Index Scan) in Oracle | Oracle Database Performance Tuning Tutorial -7       A … Continue reading Optimizer Access Paths & Join Operators ( Hash Join, Nested Loop ) in Oracle | Oracle Database Performance Tuning Tutorial -8