Home Forums SQL Server 2005 Administering SQL 2005 - SELECT query takes long time to retrieve RE: SQL 2005 - SELECT query takes long time to retrieve

  • July 20, 2010 at 7:19 am

    #1195494

    balasach82 (7/20/2010)

    SQL 2005 - SELECT query takes long time to retrieve records from a table which has about 250000 records. Even a top 10 takes 4 to 5 mins. Any remedial measures?

    Not without seeing the query, no. You will get some help if you post the query.

    You will get better help if you post the execution plans as already suggested.

    For the best help, post the table definition as well, including any indexes, triggers etc along with some sample data.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden