• At the very least please post the Actual Execution plan and give us some insight as to why you want it to optimize it in the first place - is it taking a long time to run? Generating significant high reads? Etc?

    As Gail has stated, to really test and give you the best answer we need sample data and the DDL for the tables involved (so we can run it as well)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience