How to create index in the Stored Procedures

Question

Hi i need know how to create index in the stored procedures. because i need to reduces time in sp to executes. my sp have 9000 records but it will take 30 min when multiple user login.so how can i reduces time for sp.i google it but no find any solution

sadhana belge · Answer

i find out my answer in this link: http://www.sqlteam.com/article/optimizing-performance-indexes-on-temp-tables

Raja T · Answer

Hi Please checkout bellow urls 1) http://stackoverflow.com/questions/17242597/how-do-i-create-an-index-inside-a-stored-procedure 2) http://stackoverflow.com/questions/1497181/sql-server-doesnt-use-index-in-stored-procedure 3) http://stackoverflow.com/questions/17246078/how-do-i-create-an-index-from-a-stored-procedure-or-create-index-on-every-table