Reads on Insert?

• stephan.koeppen

  SSC Enthusiast

  Points: 122

  More actions

  July 8, 2010 at 3:31 am

  #237311

  Hello,

  im fairly new to SQL Stuff but I was wondering when I saw that during an insert which causes 8 writes, 121 reads occur?

  The statement looks like this

  insert into table (col1, col2, col3, etc)

  values (@P1, @P2, @P3, etc)

  Is this because its checking indexes and constraints etc before insert? How can I determine what exactly is read during the insert?

  If we talk about 1 read, is that a page or a sector or what exactly is 1 read or write?

  Thanks in advance for your help.

  Regards, Stephan

  EDIT: //

  After checking in the query execution plan i get a little more information but it onl does 3 clustered index seeks even though it has way more foreign keys ti check.

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  July 8, 2010 at 8:11 am

  #1190261

  it has to insert it in the right place in the clustered index, so it has to look up where to insert it to