causing full table scan

Hi list , In one of my queries if I use in where clause it is causing full table scan . If i use "IN " ( ) it uses index . Actually if it is" " the it is doing hash join and if"IN" then nested loop . when i make opt_indx_cost_adj to 5 it starts usin

RE: causing full table scan

ORACLE-LSubject: causing full table scan Hi list , In one of my queries if I use in where clause it is causing full table scan . If i use "IN " ( ) it uses index . Actually if it is" " the it is doing hash join and if"IN" then nested loop . when i make opt_indx