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.

Question

Quizplus · Accepted Answer

SQL Server automatically creates indexes for foreign keys to ensure data integrity and improve performance on queries that involve foreign key relationships. This is a built-in feature to help with the efficient execution of queries that involve JOIN operations on related tables.

Which of the Following Is True About Indexes in SQL