PLAN TABLE

2010-09-14T08:40:00.000-07:00

Query:

SELECT, COUNT (DISTINCT T.DTC_CTRL_NO)
FROM DEVLBGTM.A_GTM_TCNF T
,DEVLBGTM.A_GTM_UGRP_ACS U
,DEVLBGTM.A_GTM_SMAC_AC_DTMN S
,DEVLBGTM.A_GTM_TCNF_PRTY P
WHERE U.USR_GRP_ID = 'GRP028300'
AND P.PRTY_ID = '00080901'
AND P.PRTY_ROLE_CD = '01'
AND P.DTC_CTRL_NO = T.DTC_CTRL_NO
AND T.DTC_CTRL_NO = S.DTC_CTRL_NO
AND U.SMAC_SYS_CD = S.SMAC_SYS_CD
AND U.SMAC_ACCT_NO = S.SMAC_ACCT_NO
AND T.CNFRM_STAT_CD <> 'CNCL'
;
I have following explain plan output:

PLANNO, METHOD, TNAME, ACCESSTYPE
----+---------+---------------------------------
1 0 T_GTM_TCNF_PRTY I
2 1 T_GTM_UGRP_ACS I
3 1 T_GTM_SMAC_AC_DTMN I
4 2 T_GTM_TCNF R

Can you please explain the sequence of operations here?

Economic Recession and Sri Rama Sena

2009-02-09T21:45:00.000-08:00

Hi,
Looking at the innumerable TV interviews and media publicity on the recent Mangalore incidents, I wonder - What is more important for India right now? To fight Economic Recession or to fight for Valentines day? Shouldn't the media more focussed on conducting interviews with econominsts than leaders of Sree Rama Sena..

Pour in your thoughts....

Rajesh

Various thoughts

PLAN TABLE

Economic Recession and Sri Rama Sena