#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,653
    Rep Power
    171

    Query optimization using INFORMATION_SCHEMA.PROFILING's table


    Hello;

    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


    Edit:
    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