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 10:54 am

    #1094191

    GilaMonster (12/18/2009)

    skhan-680833 (12/18/2009)

    but is it possible to do teh create index in a way so that it ignores the blank spaces?

    What do you mean? What blank spaces where?

    Almost sounds like a filtered index. Unfortunately, not available in SQL Server 2005.