Optimize MySQL Query ti may it faster

Question

I am fairly new to MySQL and would like to ask how can you fine tune this query or rewrite it in a better way.

 SELECT *
 FROM emp
 WHERE birth_date BETWEEN '1999-05-01'
 AND '1999-05-31'
 OR last_name in ('Bart', 'Martha', 'Lisa');

Your assistance is greatly appreciated. Can you also explain why you did it so I would know

Thanks.

What exactly are you trying to achieve? Is the query taking too long for the execution? — Milan Chheda, Jun 05 '17 at 11:53
Hi Milan, Sorry I was not able to clarify that. Yes it is taking time to execute — Emc_tgn15, Jun 05 '17 at 12:08

score 1 · Accepted Answer · answered Jun 05 '17 at 11:50

1

I think this question SQL Performance UNION vs OR is what you are looking for the first answer explains the difference between OR and UNION and in your case this might be the best optimization.

answered Jun 05 '17 at 11:50

Bozhidar Gorov

66
6

Thanks Bozhidar I will check this now. – Emc_tgn15 Jun 05 '17 at 11:51

score 1 · Answer 2 · answered Jun 05 '17 at 14:10

1

You can also use the EXPLAIN command to get more insight about your query and how you can optimize it.

answered Jun 05 '17 at 14:10

Liron

515
4
20

Thanks Liron, I am still learning the MYSQL and EXPLAIN seems to be a good help in this journey – Emc_tgn15 Jun 05 '17 at 15:09

Optimize MySQL Query ti may it faster

2 Answers2