QUESTION NO: 59
Evaluate the following two queries:
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 degrade in query 2
C. There would be no change in performance
D. Performance would improve in query 2
Answer: C
Explanation:
Note: The IN operator is internally evaluated by the Oracle server as a set of OR conditions, such
as a=value1 or a=value2 or a=value3. Therefore, using the IN operator has no performance
benefits and is used only for logical simplicity.
可以通过执行计划看性能,这两者之间没有差异,一样的执行计划
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29876893/viewspace-1632460/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29876893/viewspace-1632460/