• The use of isnull function should avoid the use if indexes..

    use of functions on the query predicates avoids the use of indexes

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/