Hello,
it's known problem of some BETWEEN a AMD a. You can find some other
info in archive I thing.
Please check if low is equal high and then don't use BETWEEN.
if a = b then
select ... where some = a
else
select ... where some between a and b
Regards
Pavel Stehule
On 24/12/2007, Dani C
Hi all!
I'm trying to find out a solution for this.
I paste you two queries and their query plans:
SELECT se.enduser_id
, se.enduser_number
, se.points
, se.total_messages
, sm.message_order
, to_char( se.creation_time, 'DD/MM/ HH24:MI:SS' ) as first
, MAX( to_char( s.times
