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
- 17471 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 big is nvarchar max?
Tell me in php, objects are they passed by value or by reference?
What are the differences between php3 and php4 and php5? What is the current stable version of php? What advance thing in php7?
What is inheritance in php with example?
Which is better python or php?
Write syntax to open a file in php?
How to create an array from php string?
What is new keyword in php?
What is the difference between include and require?
Define about declare construct?
Where do I run php code?
What is use of count() function in php?
Do you know design patterns. List few?
How many types of errors in php?
How to set cookies in PHP?
