Which field in the Customers table is the best candidate to index to improve database performance? Customers (CustomerID, FirstName, LastName, Address, City, Zip, Phone, BirthDate)
A)CustomerID
B)FirstName
C)Address
D)BirthDate

Question

Quizplus · Accepted Answer

CustomerID is typically a unique identifier for each record in the Customers table, making it the best candidate for indexing to improve search and retrieval performance.

Which Field in the Customers Table Is the Best Candidate