The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Projections With Expressions and Statistics

Is it possible to have projections with expressions and those projections have full statistics?  From what I can tell these only have ROWCOUNT statistics.

 

I have a handful of these projections where I'm converting numeric source data into DATE and TIMESTAMP data types on load.  However, I'm not getting the performance lift that I would expect by querying these projections instead of the anchor table.  My explain plan shows NO STATISTICS for each join and I would think that's playing a role in the lackluster query performance.

 

Any advice is welcomed, thanks.

 

Darin

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.