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.
What is true about non-equijoin statement performance? (Choose two.)
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am