locked
Auto create statistics dont works ! RRS feed

  • Question

  • Hi people,

    My SQL Server is crazy ...

    The options AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS_ASSYNC is ON.

    In one of my queries I see a "Columns With No Statistics ..." . 

    !? Why ??? If the automatic options is ON.

    more info: My Database Is COmpatibility Mode 80, but other databases also are and this not occurs.


    []s Rodrigo Ribeiro Gomes
    Thursday, March 3, 2011 11:39 AM

Answers

  • Rodrigo

    Issue some query on this column and see again


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by RodrigoRRG Thursday, March 3, 2011 12:13 PM
    Thursday, March 3, 2011 11:51 AM

All replies

  • Rodrigo

    Issue some query on this column and see again


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by RodrigoRRG Thursday, March 3, 2011 12:13 PM
    Thursday, March 3, 2011 11:51 AM
  • Thank you Uri Diamant.

    My Original query select max value of this column using MAX function.

    Since that I create the table, only this query run it.

    After of you post, i ran someone queries using only column without statistics ... And it was created.

    A detail:

    I ran the query that genrate the warning, and in the plan, it ( the warning ) was there.

    I think that was Plan Cache, then i ran with hint option(recompile) then no warnings happened more !


    []s Rodrigo Ribeiro Gomes
    Thursday, March 3, 2011 12:25 PM