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

How Vertica take the right projecton when view using in query?

I've got view created like select * from table1.
I've got two projections on table1: projection1 and projection2
I've got query which joins table1 with table2.
When I use view for join operation Vertica takes projection1 (not the right projection for query optimization) but when I use table1 in sql query Vertica take projection2.

What is the point?


PS
I know that I can use select * from projection2 in my view expression and it works.

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.