Hi: I was wondering if there is any performance-related reason to use a unique index versus a standard index? Is the only benefit of a unique index that it will prevent duplicate values from being inserted into a table unless explicitly allowed?
I have a column, colA, that I know contains only unique values because I create the table using a 'GROUP BY colA' clause. Before I use the table for any more work, I want to index colA. This table will have no further rows added to it, so I don't need to worry about a potential duplicate value being inserted. I was just wondering if it was a performance gain/hit to use a unique index, or if the difference was negligible. Thanks. Wes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
