Which statement is true regarding the above two queries?

Evaluate the following two queries: Exhibit: Exhibit: Which statement is true regarding the
above two queries?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


alexy

alexy

debatable that IN is better than OR