Hi Sanjay,
You can do a 10046 trace. Sometimes it might be caused by recursive calls,
like triger.
Regards,
Wei
2017-12-01 8:33 GMT+11:00 Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>:
Hi everyone
Need to know what factors can cause slowness for simple insert into a
table. while executing the plan it is showing Load Table conventional
operation but had big difference in the Cost in Dev vs Test. Both
environment has same data refreshed from Production.
Does Column Stat can make this difference like sample size while
collecting the data or any other advice.
TIA
Sanjay