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?

--
Andrea Gangini, Mimesi S.r.l.
[EMAIL PROTECTED]
Tel. 0521/463811

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to