Disadvantages

There are certain disadvantages to switching transaction IDs to switch plans.

The two major disadvantages of this technique are the costs of designing and developing the solution and the execution time overhead.

The cost of getting from program to program is approximately doubled. However, this should normally not correspond to more than a few percent increase in the processor time for the transaction. To decide whether or not to use such a solution, you should balance these disadvantages against the advantages.