Tuesday, September 21, 2010

A really good explanation of SQL Server and indexes

It didn't answer my current question, but it was good to read this again:
http://www.sqlteam.com/article/sql-server-indexes-the-basics

For reference: my current question was how to optimise a query which does a > comparison on two columns.... I can see how to do it using a computed column with an index, but that's not available to me at present - as I'm using Fluent nhibernate...

This question helped a bit "What happens when a function is used in the WHERE clause? In that case, the index will not be used because the function will have to be applied to every row in the table."

No comments:

Post a Comment