Right-hand inserts and optimizer reports

kxukxu Employee
edited April 1 in General Discussion

In financial businesses, all data represents some kind of time series, and the time and date columns grow constantly. All my tables partitioned by date, and each day, I add a new partition.

Analyze calculates the min/max for each column, but optimizer sometimes detects a value outside of today's range, and will sometimes misreport that only a few rows will be fetched, rather than the tens of billions that I would expect. Optimizer wants to broadcast a huge table. What's the best way to resolve this?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat

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.