MySQL Lists: mysql: InnoDB and foreign keys

List:	General Discussion	« Previous Message Next 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 keys	Ulrich Seppi	13 Oct
• Re: InnoDB and foreign keys	SGreen	13 Oct
• Re: InnoDB and foreign keys	Martijn Tonies	13 Oct
• AW: InnoDB and foreign keys	Ulrich Seppi	13 Oct
• Re: AW: InnoDB and foreign keys	SGreen	13 Oct
• Re: AW: InnoDB and foreign keys	John McCaskey	13 Oct
• Re: InnoDB and foreign keys	Gary Richardson	14 Oct
• Re: InnoDB and foreign keys	Jeff Smelser	13 Oct