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
D
0
2
JAIN your comments are useful as always very insightful I must say.
3
0
I guess D is correct, but it says ”by using the product’s unique ID”, so this table has a Primary Key, then it already has an index. But ok.. perhaps another non-clustered index.
0
0