阅读以下内容:

SQL Server数据库中的索引. [使用SQL Server 2005定义索引 [

Read these:

Indexes in SQL Server database.[^]

Defining Indexes with SQL Server 2005[^]

hope it helps :)

您可以在此处找到索引的工作方式:
http://en.wikipedia.org/wiki/Database_index [ http://geekswithblogs.net/CatherineRussell /archive/2010/06/25/5-stored-procedures-optimization-tips.aspx [ http://www.sql-server-performance.com/2003/optimizing-sp-recompiles / [^ ]，
http://sqlserverplanet.com/sql-optimization/如何使用执行计划优化存储过程 [ http://bit.ly/wbdG2i [

You can find out how indexing works here:
http://en.wikipedia.org/wiki/Database_index[^].

I cannot understand the second question. Do you mean that a stored procedure works slowly; how to improve the situation not changing its code?

First most obvious idea is actually using already written stored procedures good for some purpose, as it''s always possible to do the same job without using them.

See also these tips: http://geekswithblogs.net/CatherineRussell/archive/2010/06/25/5-stored-procedures-optimization-tips.aspx[^].

Tip #1 is the variant of my advice above, tips #2 and #4 are also not related to changing their code.

See also:
http://www.sql-server-performance.com/2003/optimizing-sp-recompiles/[^],
http://sqlserverplanet.com/sql-optimization/how-to-optimize-a-stored-procedure-using-the-execution-plan[^].

Try to find some more: http://bit.ly/wbdG2i[^].

—SA

请参见
在SQL Server中建立索引