Kiss,
Monday, June 10, 2002, 5:19:17 PM, you wrote:
KD> I studied the MySQL and InnoDB manual, but I did not find anything about
KD> the internal usage of foreign keys.
KD> I mean that I would like to know if foreign keys are used for query
KD> optimizations or functions like that.
KD> Because
: [EMAIL PROTECTED]
Subject: Re: Foreign keys in query optimization
Kiss Dániel wrote:
> I studied the MySQL and InnoDB manual, but I did not find anything
> about the internal usage of foreign keys.
MySQL does not support foreign keys at the moment. This will be
implemented in version 4.1
If you create in index on your FK then it will be used to optimize the
query.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Kiss Dániel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:19 AM
Su
Kiss Dániel wrote:
> I studied the MySQL and InnoDB manual, but I did not find anything
> about the internal usage of foreign keys.
MySQL does not support foreign keys at the moment. This will be
implemented in version 4.1.
For more info see:
http://www.mysql.com/products/mysql-4.0/index.ht
I studied the MySQL and InnoDB manual, but I did not find anything about
the internal usage of foreign keys.
I mean that I would like to know if foreign keys are used for query
optimizations or functions like that.
Because I think foreign keys should be used not only for keeping the data
integ
