What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

Even simple, this query was causing troubles on our production systems. The query is generated from .NET Entity Framework. A simple Continue reading What does an Index mean to a Query