select
   ffr.ID,
   ffr.ReestrNumber,
   ffr.ReestrDate,
   ffr.ReestrType,
   ffr.ReestrTypeEx,
   ffr.FictiveDoc,
   ffr.Accepted,
   ffr.FacialAcc_Cls,
   ffr.Summa,
   ffr.BudgetRef,
   ffr.SessionNumber,
   ffr.PacketNumber,
   ffr.Note,
   ffr.DepartmentCls,
   ffr.DocStateRef,
   ffr.CryptoStatus,
   ffr.RVersion,
   ffr.CreaterUser,
   ffr.CreateDate,
   ffr.UpdaterUser,
   ffr.UpdateDate ,
   ffc.Credit,
   ffc.Reject_CLS,
   pde.id SendID,
   rp.DisableDelCount,
   rp.ParentBlockCount,
   rp.ChildBlockCount,
   rp.COMMONPICTURECOUNT,
   rp.UNIQUEPICTURECOUNT,
   rp.RejectCount

 from
   FacialFinReestr ffr
   left join RecordParams rp on (ffr.id = rp.id)
   left join FacialFinCaption ffc on (ffc.Reestr_ref = ffr.id)
   left join PAYDOCEXCHANGE pde on (pde.PAYDOCREF=ffc.id and (pde.TypeInf BETWEEN 0 and 10))

 where
   (1=1)
   
   
and (ffr.BudgetRef=858905)and ((ffr.ReestrDate between 20170828 and 20170828))

 select
   ffr.ID,
   ffr.ReestrNumber,
   ffr.ReestrDate,
   ffr.ReestrType,
   ffr.ReestrTypeEx,
   ffr.FictiveDoc,
   ffr.Accepted,
 --  ffr.FacialAcc_Cls,
   ffr.Summa,
   ffr.BudgetRef,
   ffr.SessionNumber,
   ffr.PacketNumber,
   ffr.Note,
   ffr.DepartmentCls,
   ffr.DocStateRef,
   ffr.CryptoStatus,
   ffr.RVersion,
   ffr.CreaterUser,
   ffr.CreateDate,
   ffr.UpdaterUser,
   ffr.UpdateDate ,
   ffc.Credit,
   ffc.Reject_CLS,
   pde.id SendID,
   rp.DisableDelCount,
   rp.ParentBlockCount,
   rp.ChildBlockCount,
   rp.COMMONPICTURECOUNT,
   rp.UNIQUEPICTURECOUNT,
   rp.RejectCount

 from
   FacialFinReestr ffr
   left join RecordParams rp on (ffr.id = rp.id)
   left join FacialFinCaption ffc on (ffc.Reestr_ref = ffr.id)
   left join PAYDOCEXCHANGE pde on (pde.PAYDOCREF=ffc.id and (pde.TypeInf BETWEEN 0 and 10))

 where
   (1=1)
   
   
and (ffr.BudgetRef=858905)and ((ffr.ReestrDate between 20170828 and 20170828))

SELECT STATEMENT, GOAL = ALL_ROWS			10184	3609	606312	ALL_ROWS
 RESULT CACHE		2rvhvfg157q7j5r8v7g9vsmyc6				
  HASH JOIN OUTER			10184	3609	606312	
   NESTED LOOPS OUTER			1065	3609	544959	
    NESTED LOOPS OUTER			89	41	5412	
     TABLE ACCESS BY INDEX ROWID	BUDGET2017	TB_FACIALFINREESTR	7	41	4387	ANALYZED
      INDEX RANGE SCAN	BUDGET2017	IDX_FACIALFINREESTR_REESTRDATE	1	41		ANALYZED
     TABLE ACCESS BY INDEX ROWID	BUDGET2017	RECORDPARAMS	2	1	25	ANALYZED
      INDEX UNIQUE SCAN	BUDGET2017	PK_RECORDPARAMS_ID	1	1		ANALYZED
    TABLE ACCESS BY INDEX ROWID	BUDGET2017	TB_FACIALFINCAPTION	24	88	1672	ANALYZED
     INDEX RANGE SCAN	BUDGET2017	FK_FCFINCAPT_REESTRREF	2	88		ANALYZED
   TABLE ACCESS FULL	BUDGET2017	PAYDOCEXCHANGE	9114	1472465	25031905	ANALYZED

ID	        NUMBER(10)	N			
REESTRNUMBER	VARCHAR2(50)	N			
REESTRDATE	NUMBER	        N			
REESTRTYPE	NUMBER(10)	Y			
ACCEPTED	NUMBER(10)	N			
SESSIONNUMBER	NUMBER(10)	Y			
BUDGETREF	NUMBER(10)	N			
CREATERUSER	VARCHAR2(30)	N			
CREATEDATE	DATE	N			
UPDATEDATE	DATE	N			
UPDATERUSER	VARCHAR2(30)	N			
PACKETNUMBER	VARCHAR2(20)	Y			
FICTIVEDOC	NUMBER(10)	Y			
FACIALACC_CLS	NUMBER(10)	N			
SUMMA  	        NUMBER(15,2)	N	0		
NOTE	        VARCHAR2(255)	Y			
REESTRTYPEEX	NUMBER(10)	N			
RECORDINDEX	NUMBER(10)	Y			
DOCSTATEREF	NUMBER(10)	Y			
RVERSION        NUMBER(10)	Y	0		
CRYPTOSTATUS	NUMBER(10)	Y			
DEPARTMENTCLS	NUMBER(10)	N