Venu,
How may records? If it's just a few hundred, a full table scan might be faster.
Throw a RULE hint at it and see what happens then.
What version of Oracle? CBO in 7.3.4 wasn't all that smart.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Venu Gopal Andem [SMTP:[EMAIL PROTECTED]]
List,
I have the following scnario:
I'm doing a select from 2 tables joining them using a primary key- ref
key on the tables and the explain plan is showing 2 full table scans...
Even after analyzing the tables and the Optimizer mode is set to CHOOSE.
SELECT a.col1, b.col2
FROM table1 a, table2 b
WHERE a.col1 = b.col1
Any comments...
Thanks in advance,
Venu