I have the following table; I renamed the columns a & b for easy reading:
ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY, aID INT(9), bID MEDIUMINT(7), UNIQUE ab (aID, bID) INDEX b(bID) As far as I understand the UNIQUE INDEX also provides the index for aID, but not bID. Is there any other way to have a UNIQUE INDEX across aID & bID that will also provide an INDEX individually for the 2, or do I still have to build a second INDEX separately just for bID? I'm using MySQL 4.0.1, maybe a new version has a better way to do this? Thank you in advance... Andrew --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
