Re: indexing unique fields

2001-02-12 Thread Rus
I think that KEY is the same as INDEX, but why UNIQUE? - Original Message - From: TJ Hunter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 3:49 AM Subject: indexing unique fields I'm using the following table to store information about a merchant user. He

Re: indexing unique fields

2001-02-12 Thread btjones
You don't need the INDEX (email) at the end of this statement, it's creating a second index on the same data. UNIQUE specifies that an index should be created. TJ Hunter [EMAIL PROTECTED] wrote: I'm using the following table to store information about a merchant user. He uses his email