I was wondering if it using ‘BETWEEN’ is faster than the inequality for date range.

SELECT * FROM TABLE
WHERE LAST_UPDATE_DATE >= DATE '2024-07-01'
  AND LAST_UPDATE_DATE <= DATE '2024-07-05'

or

SELECT * FROM TABLE
WHERE LAST_UPDATE_DATE BETWEEN DATE '2024-07-01'
                           AND DATE '2024-07-05'

I tried the explain plan but it wasn’t that different between these two operations. Your opinions are greatly appreciated.

There weren’t enough data in my test instance so I only tested with small rows of data, but would like to see how the performance is when the data size grows.