Options

Stats not reflected in System tables

esangrameesangrame ✭
in General Discussion

Hi ,

I'm collecting statistics on the column and the whole table, but it is not reflected in the projections and projection_columns table.

Tried executing analyze_statistics with 100%, but still couldn't see it in system tables.

Please let me know if I'm missing anything.

Comments

  • Options
    esangrameesangrame ✭

    Got the answer, it is because the table was full refreshed after the stats was collected. So a table with 0 columns won't collect any stats.
    I hope my assumption is correct.

  • Options
    emorenoemoreno Employee

    Yes, your assumption is correct, no data, no statistics.

  • Options
    esangrameesangrame ✭

    Thank you.
    One more doubt. I have collected stats on the tables and columns with which I join the two tables.
    But in the explain plan it shows NO STATISTICS.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...