Re: Oracle 9: Date Compare Performance
From: <MrBanabas_at_googlemail.com>
Date: Fri, 30 Jan 2009 06:01:53 -0800 (PST)
Message-ID: <ab3a21a1-dae0-4465-81a7-0c41e84140d6_at_r15g2000prd.googlegroups.com>
> This query seems to hide that SCHEDULE is the same table as
> ova_schedule. Am I correct in this?
That was my mistake... yes they are the same.
Date: Fri, 30 Jan 2009 06:01:53 -0800 (PST)
Message-ID: <ab3a21a1-dae0-4465-81a7-0c41e84140d6_at_r15g2000prd.googlegroups.com>
> This query seems to hide that SCHEDULE is the same table as
> ova_schedule. Am I correct in this?
That was my mistake... yes they are the same.
> Furthermore, your only checking for complete overlaps (includes), not
> partial overlaps. Correct?
That s correct.
-- VolkerReceived on Fri Jan 30 2009 - 08:01:53 CST