List:General Discussion« Previous MessageNext Message »
From:Ulrich Seppi Date:October 13 2004 3:33pm
Subject:InnoDB and foreign keys
View as plain text  
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.

is the same query faster on DB1 or DB2?
regards
Uli

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