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
>
>
