Will SQL table indexing improve LINQ statement performance?

Question

Sorry for what can be a very stupid question.

I'm just intrigued that (a) indexing will improve performance (b) how will it improve performance and (c) why will it improve performance?

Also, if this improves performance, will this be the case across the board for LINQ to SQL, LINQ to Entities, LINQ to Objects, etc. etc.

Again, if this is a really stupid question, I apologize.

Answer 1

, LINQ SQL, , , Linq-To-Sql, LINQ SQL ( ).

, , , LastName Customers.

var results = from c in db.Customers
    where c.LastName == 'Smith'
    select c;

Answer 2

SQL - .

, ( "small" < 3000 ).

30% , , , .

, , , where ( , LINQ) .

, , (, "ON" ), . .

Answer 3

, . LINQ SQL- ... , , ... , .

Answer 4

, . . , .

http://www.sql-server-performance.com/tips/optimizing_indexes_general_p1.aspx

select, insert update , .

Answer 5

LINQ to SQL SQL, , Linq pad. SQL Server, .

• - .
• - .
• ? .

, , LINQ to SQL, LINQ , LINQ to Objects .. .

The answer to this question is: what is the relationship of the SQL table with the object?