Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_cityFROM customers
WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or
cust_credit_limit = 3000
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.
There would be no change in performance.
C.
Performance would degrade in query 2.
D.
Performance would improve in query 2.
Explanation:
http://oraclexpert.com/restricting-and-sorting-data/