Which fields should you index in a table?
A)every field
B)fields that are commonly used for sorting
C)fields that contain sensitive data
D)fields that are not part of a relationship

Question

Quizplus · Accepted Answer

Indexing fields that are commonly used for sorting can significantly improve the performance of queries that sort on those fields, as the database can quickly locate the data without scanning the entire table.

Which Fields Should You Index in a Table