How to analyze statistics on local temporary tables in vertica

How to analyze statistics on local temporary tables in vertica ?

Vertica Database Version - 7.2.3

Comments

  • SruthiASruthiA Vertica Employee Administrator

    Temporary tables are session scoped. Why do you want to analyze statistics on them?

  • Hi Sruthi, 

     

    Temporary tables that are getting created are huge in size and are further used in joins in the same session. Un analyzed or no statistics are creating wrong query plans.

     

    I can now analyze them. I was passing wrong command to analyze them.

  •  Hi ,

     

    ANALYZE_STATISTICS is supported on local temporary tables and you must create the table with the option ON COMMIT PRESERVE ROWS.

     

     

  •  Make sure you also watch the sort key as well

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file