OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
Parse         4        0 . 15         0 . 30            1            0            1             0 
Execute       5       17 . 66        26 . 19            0            0            4             1 
Fetch         0        0 . 00         0 . 00            0            0            0             0 
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
total         9       17 . 81        26 . 49            1            0            5             1 

Misses in library cache during parse:  4 
Misses in library cache during execute:  1 


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
Parse       234        0 . 72         1 . 42            9            0            9             0 
Execute   44843       41 . 69       270 . 26        23442       728184        28508         26874 
Fetch     41328       93 . 28       774 . 57       108942      8888484           75         40292 
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
total     86405      135 . 69      1046 . 25       132393      9616668        28592         67166 

Misses in library cache during parse:  39 

select 
		r.fd_anketa,
	    z.month_,
	    z.year_,
	    h.progr_,
	    u.sotr_,
	    sum(u.Sum_dogovor) Sum_dogovor
	from dogovors u,
	    (select *
	    from anketa r
	    where  r.type_anketa =  78 ) r,
	    (select * from history where progr1 in ('1','2','3','8')) h,
	    calendar z,
	    (select * from temp where temp_n =  161 ) rt
	where u.date_dogovors between rt.fd_temp and rt.td_temp
	    and (r.old_ != 'Y' or ( r.old_ = 'Y' and r.fd_anketa < rt.fd_temp))
	    and u.sotr_=r.sotr_
	    and u.date_dogovors between z.fd_calendar and z.td_calendar
	    and h.sotr_=u.sotr_
	    and h.year_=z.year_
  	    and h.month_=z.month_
	    and (z.fd_calendar between rt.fd_temp
		and rt.td_temp or td_calendar between rt.fd_temp and rt.td_temp)
	    and
	        (
	            ( rtrim(u.progr_) in ('1','2','3','8') and u.type_dogovors not in ( 11 , 5 ) )
	            or
	            ( rtrim(u.progr_) = '6'
	                and u.dogovor_ in
	                    (select dogovor_
	                    from factura
	                    where dogovor_ = u.dogovor_
	                        and progr_ = '6'
	                        and (inv_code in ('1.12','22.65','444.58')
	                            or inv_code like '3%.2')
	                    )
	            )
	            or
	            ( rtrim(u.progr_) = '3'
	                and u.type_dogovors in ( 11 , 5 )
	                and u.dogovor_ in
	                    (select distinct k.dogovor_
	                    from factura k, price_list c
	                    where k.dogovor_ = u.dogovor_
	                        and k.inv_code = c.inv_code and k.progr_ = c.progr_
	                        and k.skidka = c.skidka 
	                        and c.progr_ = '3' and c.dsc like '%2.6%'
	                    )
	            )
	        )
group by r.fd_anketa, z.month_, z.year_, h.progr_, u.sotr_
order by u.sotr_, z.year_, z.month_