Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.