Same SELECT used in an INSERT has different execution plan
- by amacias
A customer complained that a query and its INSERT counterpart had different execution plans, and of course, the INSERT was slower.
First lets look at the SELECT :
SELECT ua_tr_rundatetime, ua_ch_treatmentcode, ua_tr_treatmentcode, …