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.

How to use regular expression in pattern match conditions?

1015

---

What are the indexes in mysql?

1078

---

Why we use mongodb instead of mysql?

1016

---

Can a table have multiple primary keys?

949

---

What is the difference between truncate and delete in mysql?

1172

---

How do I find mysql location?

1007

---

What mysql means?

1008

---

Explain the difference between delete and truncate.

1038

---

What is a mysql view?

908

---

In which language mysql has been written?

1389

---

How to increment dates by 1 in mysql?

1079

---

How do you insert a table?

969

---

How do I kill a mysql query?

953

---

Does mysql support sequence?

992

---

can you tell how can you display the maximum salary in sql? : Mysql dba

920

---