Bug #1179 | Forcing indexes for foreign keys (InnoDB) | ||
---|---|---|---|
Submitted: | 2 Sep 2003 8:08 | Modified: | 30 Oct 2004 9:11 |
Reporter: | Van Panyanouvong | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
Version: | 4.0.12 | OS: | Windows (Windows, AIX) |
Assigned to: | CPU Architecture: | Any |
[2 Sep 2003 8:08]
Van Panyanouvong
[30 Oct 2004 9:11]
Heikki Tuuri
Hi! MySQL-4.1 now automatically creates the index on the FOREIGN KEY. However, it does not create an index on the REFERENCED key. That is not a big problem, because in most cases the referenced key is the PRIMARY KEY of the referenced table. Best regards, Heikki