Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why mysql is so popular?
What is delimiter in mysql trigger?
Where is the myisam table stored?
Write a query to count the number of rows of a table in mysql.
How does php communicate with mysql?
What is the use of mysqli_connect in php?
How many rows can be inserted in mysql at a time?
What is longblob in mysql?
How internally data stores in MyISAM and INNODB table types?
How to store values to array from mysql database in php?
Can you shard mysql?
Restore database (or database table) from backup.
Are stored procedures precompiled?
What is the difference between truncate and delete?
What are the 3 main types of search queries?
