What is true about non-equijoin statement performance?
A. The BETWEEN condition always performs less well than using the >= and <= conditions.
B. The join syntax used makes no difference to performance.
C. Table aliases can improve performance.
D. The BETWEEN condition always performs better than using the >= and <= conditions.
E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
BC
B is answer
B
B. The join syntax used makes no difference to performance.
C