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
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