title: Does creating a unique constraint on a column automatically create index?
body: <p>Consider this unique constraint:</p>
  
  <pre><code>ALTER TABLE Posts
  ADD CONSTRAINT UQ_Posts_Name
  UNIQUE (Name);
  </code></pre>
  
  <p>Does it automatically create index on <code>Name</code> column?</p>