PrepAway - Latest Free Exam Questions & Answers

which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID colum

The following query is executed frequently against the SALES table: SELECT sales_id,
sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which
statement will create an index for optimal query performance and ensure uniqueness of the
SALES_ID column?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

B.
CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

C.
CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

D.
CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

Explanation:


Leave a Reply