Re: sql using full table scan instead of an index
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Fri, 31 Oct 2003 12:45:23 -0500
Message-ID: <3546265.1067622323_at_dbforums.com>
Date: Fri, 31 Oct 2003 12:45:23 -0500
Message-ID: <3546265.1067622323_at_dbforums.com>
Try giving it a HINT:
select /*+ INDEX(CHILD pkey) */ CHILD.*
from CHILD, PARENT
where PARENT.value=100
and CHILD.pkey=PARENT.pkey
and PARENT.vdate between date1 and date2;
-- Posted via http://dbforums.comReceived on Fri Oct 31 2003 - 18:45:23 CET