Fast Path INSERT … SELECT Requests
There are several restrictions that must be observed in order for the high performance fast path optimization to succeed in a multistatement request.
These rules are as follows:
If you insert other statement types into the multistatement request, the fast path optimization does not occur (only the first INSERT … SELECT in the series is optimized) and performance degrades accordingly.