Which query would use the UPPER_NAME_IDX index?

Evaluate the following SQL statement: CREATE INDEX upper_name_idx ON
product_information(UPPER(product_name)); Which query would use the
UPPER_NAME_IDX index?

Evaluate the following SQL statement: CREATE INDEX upper_name_idx ON
product_information(UPPER(product_name)); Which query would use the
UPPER_NAME_IDX index?

A.
SELECT UPPER(product_name) FROM product_information WHERE product_jd =

2254;

B.
SELECT UPPER(product_name) FROM product_jnformation;

C.
SELECT product_id FROM product_jnformation WHERE UPPER(product_name) IN
(‘LASERPRO’, ‘Cable);

D.
SELECT product_jd, UPPER(product_name) FROM product_information WHERE
UPPER(product_name)=’LASERPRO’ OR list_price > 1000;



Leave a Reply 1

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


Dmitry

Dmitry

“ะก” is classic.
But “B” can correct too if optimizer choose to use index instead of table.
And optimizer in “C” can use table instead of index.