Does LINQ2SQL use table indexes?

Question

Does LINQ2SQL use table indexes when executing a query?

Answer 1

The database table indexes are used by the database itself when compiling the SQL execution plan that LINQ2SQL gives it to execute. It is completely hidden from LINQ2SQL, which itself is sent via ADO.NET to access the database.

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

Answer 2

LINQ2SQL SQL, MS-SQL . .

, LING2SQL .