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.
in reply to Re^8: For a better efficiency and speed question!
in thread For a better efficiency and speed question!