How many cl_clcodes does the subselect return and how does that number compare to the cardinality of the VW_NSO_1 view in the explain plan? At 11:03 AM 6/22/2004, you wrote: >Mark, >I tried both the options suggested by you. Following is the result. > >Thought 1. >Query > >SELECT sum(nvl(as_ofcsh,0)),sum(nvl(as_offxd,0)), > sum(nvl(as_ofeqty,0)),sum(nvl(as_ofai,0)) > FROM assets_view > WHERE as_clcode in ( select cl_clcode from perfclient,client > WHERE cl_decmkr=3D'64501013' > AND cl_clcode=3Dpc_clcode > AND pc_prfcomb in ('B', 'Y') > AND pc_grpdte != '0000-00-00' -- dkumar added > AND > substr(pc_grpdte,1,4)||substr(pc_grpdte,6,2) <= '200312') > and as_date ='200312' regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------