Understanding Entity Framework and Sql indexes

added by brianjlowry
6/30/2014 9:52:03 PM


In my consulting experience, one of the most frequently overlooked performance issues I see with web applications is the lack of properly-constructed database indexes. Microsoft’s Entity Framework has helped alleviate some of these issues by automatically creating indexes on foreign key constraints – a necessity for domain models with complex object types. While these indexes will speed up queries, most applications are more than likely missing even more important non-clustered indexes for frequently used database calls.