07-31-2023, 06:46 AM
It depends. On MySQL an index is created if you don't create it on your own:
>MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an index is created.
Source:
The same for MySQL 5.6 eh.
>MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an index is created.
Source:
[To see links please register here]
The same for MySQL 5.6 eh.