Post reply

increase the performance of "insert into selectfrom query"

  • April 14, 2010 at 4:48 am

    #217866

    I have "insert into selectfrom query" in my Stored Procedure, I want to optimize my SP.

    can u please tell me how to optimize the query.

  • April 14, 2010 at 6:52 am

    #1151296

    With the information you provided it's impossible to give an answer.

    You could start by reading this[/url].

    -- Gianluca Sartori

  • April 14, 2010 at 12:02 pm

    #1151609

    solipeta.veena (4/14/2010)

    I have "insert into selectfrom query" in my Stored Procedure, I want to optimize my SP.

    can u please tell me how to optimize the query.

    Bare minimum, you have to attach the .sqlplan file.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply