title: Why am I causing a Clustered Index Update?
body: <p>I'm executing the following statement:</p>
  
  <pre><code>UPDATE TOP(1) dbo.userAccountInfo
  SET           Flags = Flags | @AddValue
  WHERE         ID = @ID;
  </code></pre>
  
  <p>The column 'ID' is an INT PRIMARY KEY with IDENTITY constraints.
  Flags is a BIGINT NOT NULL.</p>
  
  <p>The execution path indicates that a Clustered Index Update is occurring.  A very expensive operation.
  There's no indexes covering Flags or ID, except for the primary key.
  I feel like the actual execution path should be:</p>
  
  <p>Clustered Index Seek => Update</p>