From: Peter Brawley Date: November 17 2005 10:12pm Subject: Re: A "key" question List-Archive: http://lists.mysql.com/mysql/191811 Message-Id: <437D005C.6020706@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-437D005C5D1B=======" --=======AVGMAIL-437D005C5D1B======= Content-Type: multipart/alternative; boundary=------------050507070102030805000106 --------------050507070102030805000106 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Mikhail, >Is it possible or makes sense to key a field that is a part of Unique >Index already? MySQL won't stop you, but it's a waste of space & cpu cycles unless there's a high-priority query performance need for it. PB ----- Mikhail Berman wrote: >Hello everyone, > >Is it possible or makes sense to key a field that is a part of Unique >Index already? > >Regards and thank you > >Mikhail Berman > > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 > > --------------050507070102030805000106 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Mikhail,

>Is it possible or makes sense to key a field that is a part of Unique
>Index already?

MySQL won't stop you, but it's a waste of space & cpu cycles unless there's a high-priority query performance need for it.

PB

-----

Mikhail Berman wrote:

Hello everyone,
 
Is it possible or  makes sense to key a field that is a part of Unique
Index already?
 
Regards and thank you
 
Mikhail Berman


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005

--------------050507070102030805000106-- --=======AVGMAIL-437D005C5D1B======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 --=======AVGMAIL-437D005C5D1B=======--