List:General Discussion« Previous MessageNext Message »
From:Gary Richardson Date:October 14 2004 2:40am
Subject:Re: InnoDB and foreign keys
View as plain text  
It would increase performance if your tables didn't have the indexes
required for the foreign keys prior and the queries were able to use
those indexes.

When creating foreign key constraints, the columns involved must be indexed.. 


On Wed, 13 Oct 2004 18:11:58 +0200, Martijn Tonies <m.tonies@stripped> wrote:
> 
> > 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/mysql?unsub=1
> 
>
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