What is true about non-equijoin statement performance? (Choose two.)
Posted: Sun Jun 11, 2023 3:54 pm
What is true about non-equijoin statement performance? (Choose two.)
A. The BETWEEN condition always performs less well than using the >= and <= conditions.
B. The BETWEEN condition always performs better than using the >= and <= conditions.
C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
D. Table aliases can improve performance. E. The join syntax used makes no difference to performance.
A. The BETWEEN condition always performs less well than using the >= and <= conditions.
B. The BETWEEN condition always performs better than using the >= and <= conditions.
C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
D. Table aliases can improve performance. E. The join syntax used makes no difference to performance.