locked
Custom Statistics Show No Details RRS feed

  • Question

  • I made a custom statistics object for a partitioned table. There's no information available in the details pane of the Statistic. Then I ran the following command and there's still no information. What am I missing?

    update statistics TableName(StatisticsName) with sample 75 percent, norecompute


    DJ Baby Anne's Biggest Fan................
    Wednesday, January 12, 2011 8:56 PM

Answers

All replies

  • <form id="aspnetForm" action="edit" enctype="application/x-www-form-urlencoded" method="post">

    Hi,

    Do you see details for any other statistics using details pane?

    You can use:

    DBCC SHOW_STATISTICS (N'TableName', 'StatisticaName')

    And to list stats:

    EXEC sp_helpstats @objname = 'TableName', @results = 'STATS' or 'ALL'

     

    Regards,

    Akim

     

    </form>
    Wednesday, January 12, 2011 10:14 PM
  • Yes. I see stats info for the statistics of clustered indexes.
    DJ Baby Anne's Biggest Fan................
    Thursday, January 13, 2011 2:13 PM
  • Yes, it displays info for indexes, but not for statistics without corresponding index and that's how that pane is trying to retrieve statistics info. It's been submitted as a bug: http://connect.microsoft.com/SQLServer/feedback/details/590563/statistics-properties-details-no-statistics-information-available

    Regards,

    Akim

    • Marked as answer by Abercrombie07 Monday, January 17, 2011 2:23 PM
    Thursday, January 13, 2011 4:46 PM
  • Thanks Akim. Do I get points for finding a bug?


    DJ Baby Anne's Biggest Fan................
    Thursday, January 13, 2011 6:12 PM
  • I don't assign points :)
    Friday, January 14, 2011 5:43 PM