List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:October 13 2004 4:11pm
Subject:Re: InnoDB and foreign keys
View as plain text  
> 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

Thread
InnoDB and foreign keysUlrich Seppi13 Oct
  • Re: InnoDB and foreign keysSGreen13 Oct
  • Re: InnoDB and foreign keysMartijn Tonies13 Oct
    • AW: InnoDB and foreign keysUlrich Seppi13 Oct
      • Re: AW: InnoDB and foreign keysSGreen13 Oct
      • Re: AW: InnoDB and foreign keysJohn McCaskey13 Oct
    • Re: InnoDB and foreign keysGary Richardson14 Oct
  • Re: InnoDB and foreign keysJeff Smelser13 Oct