Oracle Database Administration I — Question 141

What is true about non-equijoin statement performance?

Answer options

• A. The BETWEEN condition used with a non-equijoin always performs better than when using the >= and <= conditions.
• B. The BETWEEN condition used with a non-equijoin sometimes performs better than using the >= and <= conditions.
• C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
• D. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
• E. The join syntax used makes no difference to performance.

Correct answer: E

Explanation

The correct answer is E because the performance of database queries using different join syntaxes generally does not significantly vary. While specific cases may show differences, the overall performance is more influenced by indexes and data distribution rather than the join syntax itself. The other options suggest absolute performance comparisons which are not universally true.