Full table scan

[Venu Gopal Andem]

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

**************************Disclaimer************************************************** 
   
 
 Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged' 
and 'confidential' and intended for use only by the individual or entity to which it 
is 
addressed. You are notified that any use, copying or dissemination of the information 
contained in the E-MAIL in any manner whatsoever is strictly prohibited.

****************************************************************************************