It will choose indexed access if it has lower cost than table scan.
如果使用索引的开销比表扫描的开销低,优化器将选择索引访问。
You certainly don「t want to pay that extra price if you require maximum insert/update/delete performance and don」t need indexed access based on assistant names.
如果想得到最佳的插入/更新/删除性能,并且不需要根据助手姓名进行基于索引的访问,那么当然不想花费额外的代价。
Overall - it「s definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这确定是一个好事。事实上,你能够觉察对索引拜会路径更强的溺爱,这将波及功能。
Overall - it」s definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这肯定是一个好事。事实上,你可以发现对索引访问路径更强的偏好,这将影响性能。