title: Creating an index in a SQL Server Stored Procedure
body: <p>I have a requirement to create an index on a table in sql server for optimising a particular SP. Is that okay if I create the index in the SP, do my tasks and in the end drop the index so that the other SPs are not effected by my index? Will it disturb the equilibrium or any cons of this technique? The table contains 3 million rows.</p>