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
- 17247 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 many types of php frameworks are there?
Explain about the connective abilities of the PHP?
What is fetch array in php?
How to split a string into array using php?
How do I check if a given variable is empty?
How to write in a file in php?
Why print_r is used in php?
Is null empty php?
What is php and sql?
Is PHP an open source software?
What percentage of websites use php?
How do you check is php not empty?
What is the most common http method?
How do sessions work in php?
Is php open source?
