How can we optimize or increase the speed of a mysql select
query?
Answer Posted / david
You can optimize sql queries using dbForge Studio for MySQL:
1. Open a query file -> click the Query Profiling Mode button on the SQL toolbar -> the Query Profiler tool.
2. Execute the query by clicking the Execute button or F5. The Profiler document view opens. See the query profiling results displayed on three tabs - Profile, Plan and Status.
3. After you have made changes in the query, click the Get New Results button in the Profiler document view. New profiling results appear in the tree view as a new node with time and date of query execution. You can easily distinguish and navigate to them.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find the position of the first occurrence of a substring in a string?
what are the differences between php and perl
Require_once(), require(), include(). What is difference between them?
What is $_ files in php?
Is php case sensitive?
What is the use of namespace in php?
Write a php script to get the largest key in an array?
What is phpsessid?
Tell me what does the scope of variables means?
How to redirect a page in php?
What is the difference between php and cakephp?
Can we use onclick in submit button?
What is the default session out time?
Does php have multiple inheritance?
What are the three parts of an http request?