Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicky_river
Yak Posting Veteran
55 Posts |
 Posted - 2010-08-07 : 06:01:07
|
| Hi,Could anyone tell me how adding indexes helps in optimization of a stored procedure ? |
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-07 : 07:26:52
|
| http://blog.sqlauthority.com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/just go on through the linkWith RegardsKashyap M |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-07 : 07:53:31
|
| index help you to speed up any query (either within stored procedure or function, etc.).i suggest you to read firstly something on indexing and you will surely do 99% of the optimization. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-08-08 : 13:19:28
|
| As well as implementing indexes - do some research on maintaining indexes - such as statistics and fragmentation managementJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Question on Indexes