What will make this type of search more efficient?

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product’s unique ID.

What will make this type of search more efficient?
A . a cursor
B . a subquery
C . a trigger
D . an index

View Answer

Answer: D