Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning On which column to create index if no where clause is present ? RE: On which column to create index if no where clause is present ?

  • November 18, 2013 at 1:02 am

    #1667041

    Koen Verbeeck (11/18/2013)

    Maybe - and just maybe - you might benefit from a (clustered) columnstore index - if you're using SQL Server 2012 or 2014 - because those indexes compress the data really efficient and you might get less IO.

    and whether the table is read only or not (SQL 2012).

    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