Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning need one doubt clarification application team trying to execute a simple query RE: need one doubt clarification application team trying to execute a simple query

  • November 24, 2012 at 2:09 am

    #1561963

    naga.rohitkumar (11/22/2012)

    or after rebuilding the table wheter we have to rearrrange the colums of the table which previous ly having

    Order of columns in a table has no meaning.

    can we rebuild the index if we do so will it increase performance of the query

    Probably not. To make a query run faster, tune the query. May involve rewriting the query, may involve indexes.

    Chapters 3, 6 and 7 http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    and

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    (both of which I have referred you to before)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass