Interested to Buy Any Domain ? << Click Here >> for more details...
How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 17008 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 submit a form without using submit buttons?
How many days will it take to learn php?
What is a comment in php?
What is the best website to learn php?
What is default session time and path in php?
Whether it is possible to share a single instance of a memcache between multiple php projects?
What is the function to count elements in an array in PHP?
Explain converting an object?
Is array a key php?
Explain the difference between array_merge() and array_combine()?
What are getters and setters php?
What are the advantages of triggers in php?
How to assigning a new character in a string?
How can we define a variable accessible in functions of a php script?
What is the function used to change the root directory in PHP?
