For example, in SQLServer, if I have an index with 'unique' set on it, how is that different from a key?
How do I know when I want to use a Key vs. an Indexed field?