Simple Insert tuning

  • From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Nov 2017 21:33:57 +0000 (UTC)

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.
TIASanjay

Other related posts: