That's the whole question. Do foreign keys (FKs) affect query speed?
'Course the answer could lead to sub-questions <grin />, e.g., "If so, how best to optimize a query for them?" And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that can probably wait for another post. Don't think it really matters for this question, but WinXP SP2, 3G cpu, 1G RAM, PHP v4.3.11, Apache v2.0.55, MySQL v4.1.14, and user v61. Make a good day ... ... barn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]