Does LINQ2SQL make use of table indexes?

indexing, linq, linq-to-sql

Solution

Database table indexes are used by the database itself when compiling an execution plan for the SQL that LINQ2SQL gives it to execute. It's hidden completely from LINQ2SQL, which itself goes via ADO.NET for database access.

So the simple answer is, yes, LINQ2SQL uses table indexes, but only by default because the database itself uses them.

Problem

Original source