title: In a database, what is the difference betwen a key and an index?
body: <p>For example, in SQLServer, if I have an index with 'unique' set on it, how is that different from a key?</p>
  
  <p>How do I know when I want to use a Key vs. an Indexed field?</p>