auto creation of statistics

• VM-723206

  SSCrazy

  Points: 2964

  More actions

  September 16, 2009 at 11:42 pm

  #210831

  Comments posted to this topic are about the item auto creation of statistics

• September 16, 2009 at 11:48 pm

  This was removed by the editor as SPAM

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  September 17, 2009 at 2:54 am

  #1054834

  Bummer, missed a point because I overthought the question, figuring something so simple had to be a trick question.

  I know of the AUTO_CREATE_STATISTICS settings. But this setting only affects creation of statistics for columns used in a predicate. When creating indexes, statistics will always be made, regardless of this setting. I though that this was the trick the author had in mind when asking the question.

  (note to self: Remember, sometimes a question that seems simple, IS in fact simple...)

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
  

• NinjaX

  SSC Veteran

  Points: 213

  More actions

  September 17, 2009 at 7:40 am

  #1054976

  Very bad choice of words there. True or false can't be good answer to an is it possible question.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737768

  More actions

  September 17, 2009 at 8:31 am

  #1055011

  Question reworded to better match the T/F answer