DBMS_STATS.GATHER_TABLE_STATS 和 analyze

  SELECT                                                                            
    A.ID, A.DRAFTTP,A.DRAFTIDNB                                                    
   ,A.DRAFTISSEAMT ,A.DRAFTISSEDT                                               
   ,A.DRAFTDUEDT,A.DSCNTDT                                                            
   ,A.DSCNTTXLCTRCTNB,A.DSCNTINVCNB                                                
   ,A.DSCNTDSCNTAGRMTNB,A.ACCPTRNM                                                
   ,P.SPARTICIPANTFULLNAME AS ACCPTRACCTSVCR,A.DSCNTPROPSRNM                    
   ,A.DSCNTBKNM,b.SPARTICIPANTFULLNAME DSCNTBKACCTSVCR                            
   ,A.ADDTRMRK,A.NISREGISTERORRESPONSE                                           
   ,A.NBATCHREGISTERSTATUS