Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Why create statistics on every column of every table in a database. RE: Why create statistics on every column of every table in a database.

  • March 24, 2010 at 8:23 am

    #1138942

    SQLDraggon (3/23/2010)

    I told them there is no reason to do that for every column and every table ... but they insist.

    in that case you can also ask them why they forcing you to have more statisctics.

    You can refer this link http://www.sqlservercentral.com/articles/Indexing/63534/ it might help you here

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)