in reply to Re^8: For a better efficiency and speed question!
in thread For a better efficiency and speed question!

What is relative here is the 1 YEAR increment to the "date" and the 240 DAYS to the CURRENT_DATE. Therefore you are subtracting 1 YEAR from 240 DAYS which is 125 DAYS that you are using to add to the "date", which is relatively the something but less CPU processing time. I like that, I will try this and see how it will affect the performance of the query.
  • Comment on Re^9: For a better efficiency and speed question!