Press "Enter" to skip to content

Benefits of Indexing Foreign Key Columns

Andy Brownsword creates an index:

Last week I shared a script to identify foreign keys which weren’t indexed. What we didn’t discuss in detail was why it can be important to index these columns.

Here we’ll demonstrate the two areas we can see great benefits by introducing the indexes.

Read on to learn more about these two scenarios.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.