Is it beneficial to add an index to a column as part of a foreign key relationship? I have two columns that can be questioned frequently and already have foreign keys, but is it not certain that I should index them, or does the foreign key make a scene behind the curtain?
The SQL server is not created behind the scenario index, so to improve performance, all foreign key areas It is advisable to make an index.
Details and additional benefits:
Comments
Post a Comment