使用数据库索引 [英] use of database indexing

问题描述

我需要知道何时，如何以及为什么使用索引进行性能调整?任何人都可以提供一个很好的例子来学习索引，如何，何时以及为何使用索引吗?

I need to know when, how and why to use indexing for performance tuning? Can anyone provide a good example to learn about indexing, how, when and why to use indexing?

推荐答案

您可能已经知道，索引在使用时会提高性能正确，无法在这里解释所有内容.

如果您觉得查询很慢(花费更多时间来给出结果)，那么您可能必须查看执行计划，该计划将为您提供指示瓶颈所在的位置.可以通过在执行查询之前按"CTRL + M"来启用执行计划，执行查询后，您将在结果面板上看到另一个选项卡(将有三个面板分别显示结果，消息，执行计划)，并在次执行计划将建议使用SQL INDEXING脚本来微调查询-请在测试数据酶上执行此操作

我建议您对此进行一些搜索，并阅读一些有关此内容的教程/文章，以了解索引编制和前进的最佳方式

As you may already aware, indexing will improve the performance when used properly and not possible to explain everything here.

If you feel, your query is slow (taking more time to give the result) then you may have to look at the executioin plan which will give you and indication where the bottle neck is. The execution plan can be enabled by pressing "CTRL +M" prior to the query execution and once the query is executeted you will see an another tab on the result pannel ( there will be three pannels namly results,message,execution plan) and at times the execution plan will suggest an SQL INDEXING script for fine tuning the query - please do this on a test dataase

I would recommand you to do some googling on this and read some tutorials / ariticles on this to understanding the indexing and the best way forward

我建​​议您开始研究

I suggest you start researching here[^]

这篇关于使用数据库索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！