Simple Insert tuning
From: Sanjay Mishra <"Sanjay>
Date: Thu, 30 Nov 2017 21:33:57 +0000 (UTC)
Message-ID: <944227252.4949232.1512077637989_at_mail.yahoo.com>
Date: Thu, 30 Nov 2017 21:33:57 +0000 (UTC)
Message-ID: <944227252.4949232.1512077637989_at_mail.yahoo.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 30 2017 - 22:33:57 CET