To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause? Oracle Apps Interview Questions › Category: SQL › To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause? 0 Vote Up Vote Down Questions Master asked 3 years ago 1 Answers 0 Vote Up Vote Down Shailender Thallam Staff answered 3 years ago The order of join conditions does not matter as the optimizer will determine the best means for fetching the data.