Table 1 is materialized
table 2 is a view with its own transformation
I join table 1 and 2 together and expect the join column to be used as criteria to the table 1 transformation thus pushing down
I monitor my query at the database level (database 1 for table 2)
I do not see any criteria being used...
What should I look for as to why this is happening..
BTW, this seems to be the same when I insert intot a #TEMP table and join on it the same way...
Take look at Query Plan?
If the join side on Table 2 is not a dependent join, then it will retrieve all the rows based on the transformation in parallel then do the join in the Teiid engine. Maybe providing the costing information may help producing better plan.