Evaluate the following two queries: Exhibit: Exhibit: Which statement is true regarding the
above two queries?
A.
Performance would improve in query 2 only if there are null values in the
CUST_CREDIT_LIMIT column
B.
Performance would improve in query 2
C.
Performance would degrade in query 2
D.
There would be no change in performance
Check the explanation here
http://www.aiotestking.com/oracle/which-statement-is-true-regarding-the-above-two-queries-2/