Hey Folks:
I am trying to understand how LookupTableSource works and have a few questions:
1. Are there other examples/documentation on how create a query that uses it vs
ScanTableSource ?2. Are there any best practices for using this interface ?3.
How does the planner decide to use LookupTableSource vs ScanTableSource ?4. Are
there some hints/etc that can be given to the planner to force it to use
LookupTableSource ?5. Is this used only for joins or for regular queries ?6.
Can it be used for regular joins ? If so, is there any documentation/example ?
Thanks for your help.
Mans
