To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?

Oracle Apps Interview QuestionsCategory: SQLTo optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?
Questions Master asked 2 years ago
1 Answers
Shailender Thallam Staff answered 2 years ago

The order of join conditions does not matter as the optimizer will determine the best means for fetching the data.