Optimizer selection of projection
I have defined various projections for my testing. I see the optimizer is choosing the projection that has no encoding specified, as the cost is showing up low. I don't know why. I have applied encoding as per the DBD.
How can I check for cost for each of the projections that optimizer would have calculated when it has to pick one. I did not see the projection names in dc_design_query_plan_costs.
Any help, greatly appreciated