If we have implemented Index on Primary key column in Table1 and on Referenced column in Table2. But we don't have Foreign key on Referenced Column.
Can you please explain is this good to implement foreign key to utilize Index more efficiently
Mysql – Foreign Key For Index Column – MYSQL
foreign keyMySQL
Related Question
- MySQL: update instead of delete if foreign key constraint
- SQL Server – Composite Foreign Key Not Verifying All Columns
- PostgreSQL – Automatic Index Creation for Primary vs. Foreign Keys
- Oracle Foreign Key – How to Implement on Partial Primary Key
- MySQL – Foreign Key on Delete Set Null
- Sql-server – Alternative to second column for tracking a FOREIGN KEY pre-deletion
Best Answer
I might be wrong, but I don't think that the MySQL optimizer takes foreign keys into consideration. An index, on the other hand, may be very useful as a support for a foreign key.
However, the main purpose of a foreign key is completely different than what you are asking for. The purpose is to keep the database consistent and maintain referential integrity. When deciding for or against foreign keys, I think this what you should be concidering.