Table scan ....

I have this simple query:

SELECT COUNT(*)
FROM T1, T2
WHERE T1.COL1 = T2.COL2 There is a unique index on COL1 (on table T1) and a unique index on COL2 (on table T2). Then why does the Explain plan show me that Oracle is using a table scan on T1 and T2? Should it not have used indexes on both tables?

TIA
Raquel. Received on Wed Jul 28 2004 - 00:50:02 CDT