Post reply

auto creation of statistics

  • 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

  • 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/

  • 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.

  • September 17, 2009 at 8:31 am

    #1055011

    Question reworded to better match the T/F answer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply