retrieving data from three different table using join.The join takes long time to executing in mysql.
Asked
Active
Viewed 31 times
0
-
3please, paste your query and look [explain](https://stackoverflow.com/questions/10148851/how-to-optimise-mysql-queries-based-on-explain-plan) – Alberto Moro Jul 02 '19 at 06:46
-
2There is no question in this post. – philipxy Jul 02 '19 at 10:16
-
It may also help to provide `SHOW CREATE TABLE`. – Rick James Jul 02 '19 at 17:03
1 Answers
1
As mentioned by @Alberto Moro please share the explain.
Also you join query can be slow because of numerous reasons like the joins that you are implementing may not be on keys.
When you right Explain before the query it helps you detail out the query so that you can optimise it using the data.
Nirbhay Shah
- 197
- 1
- 7