1. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Next Door
    Rep Power

    Query optimization using INFORMATION_SCHEMA.PROFILING's table


    I am trying to learn a few things about optimizaiton. I am looking at the PROFILING table and check the results of a query.

    These results show that SEQ number 10 sending data is taking 7 seconds.

    What useful information can I get from this? What do I need to look at in order to make this time shorter?

    Thank you

    Also in general I'd like to know what are the main issues on optimizing that I should focus on? You know, the popular ones.
    Last edited by zxcvbnm; April 22nd, 2013 at 02:10 AM.

IMN logo majestic logo threadwatch logo seochat tools logo