> does anybody know if Foreign keys increase the performance of select querys? > example. > DB1 has only INNODB tables. > DB2 has the same structure as DB1 with all possible foreign keys. > > is the same query faster on DB1 or DB2?
Why should it increase performance? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]