title: Trying to understand sql execution plan
body: <p>I created a simple table in SQL Server:</p>
  
  <pre><code>MemberId INT PRIMARY KEY Identity
  Name NVARCHAR(100) NULL
  Description NVARCHAR(250) NULL
  </code></pre>
  
  <p>The only index that was added was a clustered index when I created MemberId as a primary key. I didn't add an index to Name or Description.</p>
  
  <p>I added about 30,000 rows of test data to the table and did the following query:</p>
  
  <pre><code>SELECT * FROM Members WHERE Name = 'Foo'
  </code></pre>
  
  <p>The execution plan said the following:</p>
  
  <pre><code>Clustered Index Scan - cost 100%
  </code></pre>
  
  <p>How is this a clustered index scan? I'm not predicating on the clustered index. I thought this would be more of a table scan. Can someone explain this to me? What exactly would cause a table scan if this does not?</p>