每个外键的索引?

作者: 艸伱犸
来源: 51数据库
2022-12-13

问题描述

每个外键上的索引都会优化查询吗??

Does Index on every Foreign Key makes queries optimized ??

推荐答案

通常将索引放在外键上被认为是一种很好的做法.这是通过 b/c 完成的，它有助于在将 FK 表链接到包含键定义的表时提高连接性能.

Typically it's considered good practice to place indexes on foreign keys. This is done b/c it helps with join performance when linking the FK table to the table that contains the definition of the key.

这不会神奇地使您的整个查询优化，但它肯定有助于提高 FK 与其主键对应部分之间的连接性能.

This doesn't magically make your entire query optimized, but it will definitely help to improve the join performance between the FK and it's Primary Key counter-part.

推荐阅读