query problem - help me

From: Ravindra K Singh <s.sethi_at_telserra.com>
Date: Sat, 24 Jun 2006 17:17:21 +0530
Message-Id: <20060624114742.A182237BF9C@turing.freelists.org>

Hello  

 if I use this query , it is taking huge time to execute ,  

but if I exclude bold lline then this is not taking time .

PLEASE HELP ME TO SORT OUT THIS PROBLEM   (we have 1 MB hash area size , is it possible to increase size from 1 mb to 10 mb )  

SELECT  T3.USR_ID ,T3.GM_ID,T3.PLY_ID ,         SUM(TTL_TCKTS ) SOLD_TICKETS ,              SUM(TTL_TCKTS*U1.PUR_PRICE ) COLL_TICKETS,        0 AS TTL_PROJ_WNN,        0 AS PROJPAYOUT   FROM ABC T3 , DEF U1 , GHI H1     WHERE T3.CNCLLD_FLG='N' AND

                        EXISTS  (

                  SELECT USR_ID

               FROM HRRCHY_USR_ID

               WHERE USR_ID = T3.USR_ID

                 )   AND

                  EXISTS  (

                     SELECT SCHM_ID

                        FROM ORG_SCHM_ID O1

                  WHERE O1.SCHM_ID= T3.SCHM_ID

                  )

          AND T3.SCHM_ID = U1.SCHM_ID

          AND H1.USR_ID = T3.USR_ID

               AND U1.USR_ID   = H1.BSS_ID  -- IN  ( SELECT STO FROM YYY

WHERE OPR= T3.USR_ID )           AND ( TRUNC(T3.trnsctn_tm) BETWEEN U1.WEF_DT AND NVL(U1.TILL_DT,SYSDATE) )           AND (TRUNC(T3.trnsctn_tm) BETWEEN TO_DATE('01/05/2006','DD/MM/YYYY') AND TO_DATE('10/05/2006','DD/MM/YYYY'))   GROUP BY T3.USR_ID ,T3.GM_ID,T3.PLY_ID /

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jun 24 2006 - 06:47:21 CDT