Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Optimizing queries / stored procedure for retreiving millions of rows

Question Optimizing queries / stored procedure for retreiving millions of rows

  • Saturday, April 22, 2006 5:20 AM
     
     
    Sign In to Vote
    0
    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.
     

All Replies

  • Saturday, April 22, 2006 11:15 AM
    Moderator
     
     
    Sign In to Vote
    0
    Hi,

    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.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---