Good day,
I don't know for sure, however as per some statistics I compiled while doing tests for another project, it looks that the BETWEEN clause could be somehow optimized.
Generally speaking :
(x>=y AND x<=z)
seems to be handled in a more efficient way than its counterpart
(x BETWEEN y AND z)
Anyone can confirm if this is applicable on their end ?
Regards.