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
> 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 Tonie
I am not certain that Foreign Keys (FKs) are even considered when
evaluating a SELECT statement. I know that the indexes that the FKs point
to in either table play a major role in determining the execution plan but
I don't think that the FKs actually participate in SELECT queries.
Now, does ha
