Which of the following is true about indexes in SQL Server?
A)SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries.
B)SQL Server pads all indexes.
C)SQL Server supports filling up to a limit of 70 percent.
D)SQL Server automatically creates indexes for foreign keys.
E)All of the above.

Question

Quizplus · Accepted Answer

SQL Server automatically creates indexes for primary keys but not for foreign keys. However, it is a common practice to manually create indexes on foreign keys to improve query performance.

Which of the Following Is True About Indexes in SQL