Tag Archives: nonequijoin

What is true about non-equijoin statement performance? (Choose two.)

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