• Chek the use of indexes, if the are not the same try to Hint them:

    ..................

    FROM Table1 (INDEX = idx_index_name)

    ............

     

    Sometimes if you use calculation in the joins it does not use the right index.