How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 16237 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
How can we change the maximum size of the files to be uploaded?
What are the rules to determine the “truth” of any value which is not already of the boolean type?
Is server side a session?
How do functions work?
Tell us how to set cookies in php?
What is slim framework?
What is an abstract class in php?
What is a php form?
What is a php namespace?
What is a trait in php?
How is a session id generated?
What are php loops?
Is php coding easy?
What are the options to transfer session ids?
What are differences between PECL and PEAR?
