statistics _WA_

• threna

  Valued Member

  Points: 56

  More actions

  September 12, 2003 at 9:28 am

  #59774

  hi all,

  I have many questions on sql server statistics _WA_.

  When I drop these statistics , the data and index storage don't decrease --> the result of sp_spaceused command on the current database doesn't change. Why ??

  To know the amount of statistics '_WA_', I use :

  select o.name as Nom_Table, i.name as Nom_Index, i.indid, i.dpages * 8 as Volume_Ko

  from sysobjects o, sysindexes i

  where i.name like '_WA%'

  and o.id = i.id and o.type = 'U'

  order by o.name

  COMPUTE SUM(i.dpages * 8 )BY o.name

  COMPUTE SUM(i.dpages * 8 )

  that is correct ?

  What is the reasons to leave Sql Server create the statistics _WA_ when the good index are created ??

  thanks for your help

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  September 12, 2003 at 10:21 am

  #473964

  The statistics are used to decide which indexes to use. They help the query optimizer to make decisions.

  I'd leave them alone.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net