update with clustered index with fillfactor = 100

Last Post 25 Sep 2007 12:45 PM by trans53. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
21 Sep 2007 09:50 AM
Hi all,

Here is the question that i need a little help:

I have a table with an identity column and a clustered index with fillfactor = 100 defined on it.

Also i have an update statement like this :

UPDATE dbo.queue
SET datestarted = GETDATE()
WHERE event_id = 12313

When i run execution plan all i have is Tsql: update:cost 0% and Clustered Index Update:cost 100%

Is this means that for every update i have a page splits even event_id column is not updated directly?

Can you please help me to understand this?

Thanks
trans53
New Member
New Member

--
25 Sep 2007 12:45 PM
Thank you
You are not authorized to post a reply.

Acceptable Use Policy