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.