Home Forums SQL Server 2008 SQL Server 2008 Administration Performance tuning RE: Performance tuning

  • February 26, 2015 at 6:13 pm

    #1780448

    ANn -425914 (2/26/2015)

    For SQL performance tuning for a query, does the order of columns in where filter clause matters?

    No, column order is irrelevant.

    Also does order of columns matter in join statement?

    Same as previous answer.

    Is the SQL internal optimizer smart enough to reorganize the order to use whatever is more efficient order?

    Yes, that's the magic of declarative languages such as SQL.

    When doing performance tuning, Oracle catches waits and use it as an import factor to analyze performance, is SQL server the same - using wait time and types as important identifier for performance?

    Thanks

    Yes, using wait time and types is part of performance tuning. You can find a complete explanation here: http://www.sqlservercentral.com/articles/books/76296/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2