Query Tuning vs. Process Tuning

New article posted:
SQL Server Performance: Query Tuning vs. Process Tuning
http://www.sql-server-performance.com/nb_query_process_tuning.asp


Shane Tasker
--
Contributing Editor, SQL-Server-Performance.Com
Independent Consultant

Hi I read ur article
good to know about the relation between noof rows and time taken.
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.

They can fly because they think they can.