List:General Discussion« Previous MessageNext Message »
From:Jasper Bryant-Greene Date:November 17 2005 9:19pm
Subject:Re: A "key" question
View as plain text  
Mikhail Berman wrote:
> Is it possible or  makes sense to key a field that is a part of Unique
> Index already?

It's possible, but it doesn't make sense. A unique index is a normal 
index with an added unique constraint. Adding another index on the same 
field would make no sense (unless the field is a rightmost part of a 
unique index).

Your question would have been answered by checking the archives less 
than a week back (this question comes up a lot) or reading the manual.

Jasper
Thread
A "key" questionMikhail Berman17 Nov
  • Re: A "key" questionJasper Bryant-Greene17 Nov
  • Re: A "key" questionPeter Brawley17 Nov
RE: A "key" questionMikhail Berman17 Nov
  • Re: A "key" questionJeremy Cole17 Nov
RE: A "key" questionMikhail Berman18 Nov
  • Re: A "key" questionJeremy Cole18 Nov
  • Re: A "key" questionMichael Stassen18 Nov
RE: A "key" questionMikhail Berman18 Nov
  • Re: A "key" questionMichael Stassen18 Nov
RE: A "key" questionMikhail Berman18 Nov
  • Re: A "key" questionDavid Griffiths18 Nov
  • Connection ProblemTripp Bishop18 Nov
    • Re: Connection ProblemMichael Stassen18 Nov
      • Re: Connection ProblemTripp Bishop18 Nov