How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 16307 Views
- I also Faced
- E-Mail Answers
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
What is php? Why it is used?
How to remove duplicate values from php array?
What are the file upload settings in configuration file?
What are the differences between PHP3 and PHP4 and PHP5? what is the current stable version of PHP?
What type of operation is needed when passing values through a form or an url?
How big is varchar max?
Write a program in php to reverse a number?
What is purpose of @ in Php?
What is if isset ($_ post submit )) in php?
What is the best way to change the key without changing the value of a php array element?
Tell me how stop the execution of a php scrip?
Why use php artisan serve?
Can we run php on tomcat server?
How to update memcached when you make changes to php?
What is php sequence?
