Re: Cost based optomizer problem. CBO won't merge view

> select *
> from a_anti_a_view av
> where av.asset_id in (select id from temp_as);

You might try re-writing query as standard join and force a nested loop join:

select /*+ use_nl */

   col_list
from

   a_anti_a_view av,
   temp_as t
where

   av.asset_id =t.temp_as; Received on Sat Jun 28 2003 - 20:49:32 CEST