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:52 am

    #1094189

    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?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass