55.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_city FROM 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.
B.Performance would degrade in query 2.
C.There would be no change in performance.
D.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
答案：C
SQL> SELECT cust_last_name, cust_city FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city FROM 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.
B.Performance would degrade in query 2.
C.There would be no change in performance.
D.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
答案：C
扫一扫
3044
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
