I am having one querry regarding the same line. In my stored procedure i am fetching the data from one table containing upto 5 to 6 million rows I made use of index in my database but then also I cant optimise my execution time of that sp. Please help me out of this problem.
Try to give us the queryplan of your query, its the best and easiest
thing to find bottlenecks. Use the query Analyzer for that or have a
look on the SET SHOWPLAN ON and activate this priot to executing the
query. It will put out a text (graphical plan) of your query where you
can see if some lame things are done.