Reflected data sources not chosen?

4

Hi @summersmd

I did look at the profile starting with ‘fa’ . I see there are 4 RAW reflections that match but not chosen. There are couple of reasons why reflections would match but not get picked (not get chosen)

  1. Costing: The cost of going back to the dataset is less than than the cost of using the reflection. Now we could be wrong sometimes and would require deeper analysis. In order for us to look at this we need the profile again after you have enabled “planner.verbose_profile” via the support key.

  2. We hit an exception during substitution. Can you please send us the server.log?

Thanks
@balaji.ramaswamy