Answer Posted / subeeshbabu v
Fine tuning is mostly done for the SELECT statements.
Use the Keyword EXPLAIN in front Of your SELECT Statement.
eg: EXPLAIN SELECT t1.id, t2.id FROM table1 AS t1 INNER JOIN
TABLE2 AS t2 ON .....;
The result will be like this
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| id | select_type | table | type | possible_keys |
key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| 1 | SIMPLE | table1 | ref | t1 |
t1 | 4 | const | 2 | Using where |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
1 row in set (0.00 sec)
if the "ref" column value is found to be ALL, then the two
tables must be joined properly. if the "Extra" gives values
like
Using temporary; Using filesort then the columns in the
JOIN conditions and WHERE clause must be indexed properly.
By doing this we can make our queries executing faster.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create a table?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How do I find mysql version in mysql workbench?
What is the full form of mysql?
What is striped backup
What is a mysql model?
What are string data types?
Can python connect to mysql?
Why is mysql used?
What is schema in mysql?
What is mysqli_result?
How do you insert a table?
How do I clear a mysql database?
How do I restore a mysql database?
What are the objects can be created using CREATE statement?