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 :
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?