MySQL Forums
Forum List  »  Optimizer & Parser

Where Clause Optimization
Posted by: Mohammed Yehia El Sayed Abdoh
Date: August 31, 2018 06:47AM

I was on the "Where Clause Optimization" section and I came to the following point:

- HAVING is merged with WHERE if you do not use GROUP BY or aggregate functions (COUNT(), MIN(), and so on).

Can someone explain this point to me with a practical example?

Options: ReplyQuote


Subject
Views
Written By
Posted
Where Clause Optimization
860
August 31, 2018 06:47AM
449
August 31, 2018 01:55PM
506
September 03, 2018 02:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.