kudz (1/29/2016)
There is no swap order possible as the first session it's just a select statement and sql choses the order it access the tables right ?
I think you missed one of the things I wrote in my earlier reply:
"For step 2 it can sometimes be needed to do a dummy select of affected rows before running the actual query. If you have no indexes, then this can be an issue."