Re: Insert into values generating a lot of logical I/O

From: Dragutin Jastrebic <>
Date: Wed, 30 Oct 2013 18:38:00 +0100
Message-ID: <>


Which has been executed 9,556 times generating more than *50 millions* of Buffers Gets.
*Questions* : How a simple insert into values could generate such a high number of logical I/O."

So you have 5232 buffer gets per simple insert.

Before investigating it further, I would verify that there is no database trigger on the table

" Table_IN "


Received on Wed Oct 30 2013 - 18:38:00 CET

Original text of this message