title: Index scan on primary key(ID)
body: <p>Query</p>
  
  <pre><code>SELECT MAX(ID) FROM Product
  </code></pre>
  
  <p><a href="https://www.brentozar.com/pastetheplan/?id=Skv5OqZBU" rel="nofollow noreferrer">https://www.brentozar.com/pastetheplan/?id=Skv5OqZBU</a></p>
  
  <p>Why optimizer uses index scan even if query is based on primary key(ID) ?</p>