Super Projections vs Query Specific Projections
I have one doubt.. if we create a query specific projection which has all columns in the base table and has same syntax of its super projection. By default which projection, vertica optimizer chooses for execution.
I mean there is no difference in Projection SQL between Super and Specific projection.
I know we can avoid super projection using SET_OPTIMIZER_DIRECTIVES('AvoidUsingProjections=').
please let me know the working of the optimizer in such case.