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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]