Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan? RE: Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan?

  • December 18, 2009 at 12:05 pm

    #1094243

    Thanks everyone. I have asked the developer to redo the query. I do not think filtered index is an option and as it is a vendor apps they build these indexes thourgh the vendor designer tools. Also I checked a few things and I think he should not put indexes on those columns and do the query in a different way. Thank you for all of your help and suggestions.

    SD Khan