Re: Simple Insert tuning

From: Ahmed Aangour <>
Date: Fri, 1 Dec 2017 07:09:52 +0100
Message-ID: <>


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.


Le 30 nov. 2017 22:34, "Sanjay Mishra" <> 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.


Received on Fri Dec 01 2017 - 07:09:52 CET

Original text of this message