Does MySQL index foreign key columns automatically?

mysql database indexing
Dónal picture Dónal · Nov 20, 2008 · Viewed 90.2k times · Source

Does MySQL index foreign key columns automatically?

Answer

Grant Limberg picture Grant Limberg · Nov 20, 2008

Yes, but only on . Innodb is currently the only shipped table format that has foreign keys implemented.

Related questions

Is the primary key automatically indexed in MySQL?

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer the same for MyISAM and InnoDB?

Read More
Two single-column indexes vs one two-column index in MySQL?

I'm faced with the following and I'm not sure what's best practice. Consider the following table (which will get large): id PK | giver_id FK | recipient_id FK | date I'm using InnoDB and from what I understand, it creates indices …

Read More
Handling very large data with mysql

Sorry for the long post! I have a database containing ~30 tables (InnoDB engine). Only two of these tables, namely, "transaction" and "shift" are quite large (the first one have 1.5 million rows and shift has 23k rows). Now everything works fine …

Read More