April 22nd, 2013, 02:07 AM
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?
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.