What is true about non-equijoin statement performance? (Choose two.)
What is true about non-equijoin statement performance? (Choose two.)
Table aliases can improve performance as they make the SQL queries easier to read and manage, which can lead to faster parsing by the database. The join syntax used does not make a difference to performance because both Oracle's traditional syntax and the SQL:1999 ANSI join syntax are optimized by the database engine to execute efficiently. Therefore, the syntax choice is more about readability and compatibility rather than performance.
Dear all, AC is correct answer for sure i faced this question in 1z0-071 exam and i select AC and got correct answers :) Regards.
A and C. There's no performance benefit or hit by using ANSI joins rather than traditional joins, but by using ANSI joins, your queries are more portable between DBMS platforms, and they're a bit easier to read. http://www.dba-oracle.com/oracle_news/2004_2_19_rittman.htm
So now we have to choose between A and C or A and E After reading through following explanation it seems to me that there are some specific cases where traditional joins perform better Source (taken from ama's post up there): https://stackoverflow.com/questions/58476906/1z0-071-oracle-exam-question-which-answers-is-correct But generally speaking there shouldn't be any big differences in performance between traditional and ansi join syntax - I am pretty sure that there are also some specific cases where ansi joins perform better than traditional joins. So in that case I would go with A and C and just hope for the best!
ORACLE will never issue a software worse than others. so A E are correct.
your point is valid and they make all joining syntax equal in performance. there is no winner
i agree, AC is the correct answer
Thin its A and C. any evidence for E?
E is correct… check this> https://stackoverflow.com/questions/58476906/1z0-071-oracle-exam-question-which-answers-is-correct so i bet on A, E
A - true; there can be a performance benefit when using table aliases B - false; there is no performance benefit difference when using keyword BETWEEN or operators <= => C - true; there is no difference in performance when using SQL 1999 ANSI join syntax or Oracle syntax D - false; see answer B E - false; see answer C Sources A - https://orawiss.wordpress.com/table-alias-speed-up-database-access/ According to the Oracle Sql fundamentals written by Nancy Greenberg and reviewed by a few technical contributors in the page 151, the Table aliases speed up database access and the Table aliases can help to keep SQL code smaller by conserving memory.
Provided answer are wrong.
AC is correct
A,C is correct
B & C looks close answers
A, E !!!
A is correct https://orawiss.wordpress.com/table-alias-speed-up-database-access/
B & E is correct one
can you Elaborate more ? is this a guess or you have evidence?