title: Is a primary key automatically an index?
body: <p>If I run Profiler, then it suggests a lot of indexes like this one</p>
  
  <pre><code>CREATE CLUSTERED INDEX [_dta_index_Users_c_9_292912115__K1] ON [dbo].[Users] 
  (
   [UserId] ASC
  )WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, 
  ONLINE = OFF) ON [PRIMARY]
  </code></pre>
  
  <p>UserId is the primary key of the table Users. Is this index better than the one already in the table:</p>
  
  <pre><code>ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [PK_Users] PRIMARY KEY NONCLUSTERED 
  (
   [UserId] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, 
  IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, 
  ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  </code></pre>