Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34:
> I have a column in one of my table, which:
> - must be unique
> - must be indexed because almost all queries are "SELECT ...... WHERE
> COLUMN LIKE ...."
>
> I created two indexes this column, one of type UNIQUE and a normal one,
> because I thought that the unique index and a normal indexes were
> different... is it really so?
>
> Could I use only the UNIQUE index also for speeding up the queries?
There is no difference between unique and non-unique indexes at search
time, so there is no point in having two indexes. The only difference is
at insert time, when the unique index enforces the uniqueness rule.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
