adspace


Does mysql automatically index foreign keys?

Answer Posted / Md Akram

No, MySQL does not automatically create an index on foreign key columns. If you want to improve performance when querying data that involves foreign key relationships, you should manually create an index on the foreign key column using the `CREATE INDEX` command.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1083


Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1104


How to Change a users password from unix shell.

1222