Avoid enclosing Indexed Columns in a Function in the WHERE clause

(Bill Graziano) When a function is wrapped around an indexed column in the WHERE clause it will usually prevent the proper usage of that index. This article gives an example and discusses what other options are available.

Read More - Register for Free Membership