> http://www.mysql.com/doc/en/SEC457.html states that "there must be an > index where the foreign key and the referenced key are listed as the > FIRST columns." Will this restriction be lifted soon? It is incredibly > frustrating. I don't see why they have to be indexes, and more > importantly, I don't see why they have to be FIRST! Ugh. > Major performance hit would be a guess. Otherwise the database would have to do a table scan. Think about how it would find the related record. I think is a requirement of db2 as well > >
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 --------------------------------------------------------------------- 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