index hint returns wrong results
From: Terrian, Thomas J CTR (US) <"Terrian,>
Date: Tue, 8 Mar 2016 12:32:34 +0000
Message-ID: <EC0CCA09F117ED43ACBDEEF40E0BB4944BD6E5E1_at_HL01DAG4MB2.DIR.AD.DLA.MIL>
Oracle 12c.
Date: Tue, 8 Mar 2016 12:32:34 +0000
Message-ID: <EC0CCA09F117ED43ACBDEEF40E0BB4944BD6E5E1_at_HL01DAG4MB2.DIR.AD.DLA.MIL>
Oracle 12c.
Am I missing something or is this a bug? Using an index hint returns the wrong results. Does it matter if the table is partitioned and the index is global or even what fields are in the index? I can't see how any of that should matter. The results should be the same:
select /*+ index(t1 ind1) */ count(*)
from scott.t1
where f1 = 'one' and f2 = ' ';
COUNT(*)
2
select count(*)
from scott.t1
where f1 = 'one' and f2 = ' ';
COUNT(*)
1
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 08 2016 - 13:32:34 CET