SQL Server Performance

Query Tuning vs. Process Tuning

Discussion in 'Performance-Related Article Discussions' started by shanetasker, Mar 28, 2006.

  1. shanetasker New Member

  2. RahulDBA New Member

    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.

Share This Page