16.03.2009

Executing Functions on Indexed Columns

Up to now we’ve learned that using functions on indexed columns is a performance issue because executing a function like cast causes SQL Server not to use indexes. In SQL Server 2008 using convert function on datetime column does not cause not using the index. Shortly SQL 2008 convert function is index awareness