SQL Server automatically creates an index on:

• A. primary keys only.
• B. foreign key only.
• C. both primary and foreign keys.
• D. SQL Server never automatically creates an index.