Hi,
Do you have any real time sql monitor to show us? This report will allow us
to see the most consuming operation in the plan and the corresponding wait
events. For example if the most consuming operation is load table
conventional and you notice cpu and db file sequential reads wait event
it's then possible that your query is spending most of its time on updating
the existing indexes in the table specifically if those indexes have a very
bad clustering factor.
Regards,
Ahmed
Le 30 nov. 2017 22:34, "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> a
écrit :
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
