It didn't answer my current question, but it was good to read this again:
http://www.sqlteam.com/article/sql-server-indexes-the-basicsFor 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