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.
0