Mike,
WheretheheckisOLN-AFMC? Okie City?
Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index.
Have you tried a hint?
select /*+ index(table1 Table1_PK_indexname) */
a.f1, a.f2, a.f3, a.f4
from table1 a
where a.f1 not in
( select b.n1 from b );
My assumption is that you have a performance problem. How many records and how long does it take? Maybe show us the entire explain plan?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Johnson, Michael [SMTP:[EMAIL PROTECTED]]
I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.
Here is the issue.....
I have a query that looks like this ...
select a.f1, a.f2, a.f3, a.f4 from table1 a
where a.f1 not in
( select b.n1 from b );
there is a primary key index on b.n1
there is a concatenated primary key index on a.f1,a.f2,a.f3
there is a non-unique index on a.f1
the query shows that the index is being used
on table b, but no indexes are being used on table a.
Mike
