Skip to main content

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

  • August 13, 2015
  • 0 replies
  • 4 views

FiliN
Forum|alt.badge.img
  • Participating Frequently

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.