How wrong is it to have a unique and normal index on the same column?...

should nearly unique fields have indexes...