Reflection 1 is a Raw Reflection on our ‘Project’ VDS with a footprint of 1.92MB
Reflection 2 is an Advanced Raw Reflection on our ‘Project’ VDS with 20 Columns and a footprint of 517.23 KB
I have a query that selects the same 20 columns that are found in Reflection 2, however
Reflection 2 is rejected as too expensive and Reflection 1 is selected instead.
I’ve attached the query profile. Can you explain why a Reflection would be rejected as ‘Too Expensive’ when it contains fewer columns and a smaller footprint than the Reflection that was chosen by the optimizer?
8a2a9b37-e8ee-4a7e-abcc-34fa8bc7be4a.zip (156.7 KB)