List:General Discussion« Previous MessageNext Message »
From:Jeff Smelser Date:October 13 2004 4:08pm
Subject:Re: InnoDB and foreign keys
View as plain text  
On Wednesday 13 October 2004 10:33 am, Ulrich Seppi wrote:

> Hello people,
> 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.

Huh? You might want to read what a foreign key is.. It has nothing to do with 
speeding anything up..

http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html

Jeff

Attachment: [application/pgp-signature]
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