To optimize the performance of an SQL statement what should be the order of tables in FROM clause?

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

For better performance order of tables in the FROM clause should be:
1. Larger tables first and then
2. Smaller table