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 add
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 a
I'm using the following table to store information about a merchant user.
He uses his email address as his username to login. Since I'm going to
be doing WHERE clauses on that field, I'd like it to be indexed for speed.
If I have a UNIQUE property on the email field when I create the table, do I
n
