1 Reply Latest reply on Mar 12, 2013 11:07 AM by Ramesh Reddy

    Joining to Materialized table isn't pushing down to other tables

    virtualdatabase Apprentice

      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...