I studied the MySQL and InnoDB manual, but I did not find anything about 
the internal usage of foreign keys.
I mean if I define a foreign key it is good for me, because the InnoDB 
engine does not let the database to get integrity errors. But I think the 
foreign key definitions could be used in query optimizations, but I did not 
find anything about it.

So, are foreign keys used in query optimizations in case of InnoDB 
databases to speed up performance?

Thanks,
        Daniel Kiss



---------------------------------------------------------------------
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

Reply via email to