OPERATION   OBJECT_NAME   OPTIONS   COST 
 SELECT STATEMENT 
          417 
    
  SORT 
      ORDER BY   417 
        
  FILTER 
            
            
  过滤谓词 
                
  AND 
                    
  OR 
                        
  NAMES5_.LANGUAGE='en-UK' 
                        
  (SELECT COUNT(NAMES10_.TASK_NAMES_ID) FROM I18NTEXT NAMES10_ WHERE NAMES10_.TASK_NAMES_ID=:B1)=0 
                    
  OR 
                        
  SUBJECTS3_.LANGUAGE='en-UK' 
                        
  (SELECT COUNT(SUBJECTS11_.TASK_SUBJECTS_ID) FROM I18NTEXT SUBJECTS11_ WHERE SUBJECTS11_.TASK_SUBJECTS_ID=:B2)=0 
                    
  OR 
                        
  DESCRIPTIO4_.LANGUAGE='en-UK' 
                        
  (SELECT COUNT(DESCRIPTIO12_.TASK_DESCRIPTIONS_ID) FROM I18NTEXT DESCRIPTIO12_ WHERE DESCRIPTIO12_.TASK_DESCRIPTIONS_ID=:B3)=0 
            
  HASH JOIN 
      OUTER   416 
                
  访问谓词 
                    
  TASK0_.ID=DESCRIPTIO4_.TASK_DESCRIPTIONS_ID(+) 
                
  HASH JOIN 
      OUTER   313 
                    
  访问谓词 
                        
  TASK0_.ID=SUBJECTS3_.TASK_SUBJECTS_ID(+) 
                    
  HASH JOIN 
      OUTER   210 
                        
  访问谓词 
                            
  TASK0_.ID=NAMES5_.TASK_NAMES_ID(+) 
                        
  HASH JOIN 
          107 
                            
  访问谓词 
                                
  TASK0_.ID=POTENTIALO9_.TASK_ID 
                            
  NESTED LOOPS 
          61 
                                
  INLIST ITERATOR 
            
                                    
  INDEX 
  SYS_C0021801   UNIQUE SCAN   1 
                                        
  访问谓词 
                                            
  OR 
                                                
  ORGANIZATI6_.ID='chm.approver' 
                                                
  ORGANIZATI6_.ID='chm.operator' 
                                                
  ORGANIZATI6_.ID='chm.teamLeader' 
                                                
  ORGANIZATI6_.ID='ff8080813962106e0139628fcd28000e' 
                                
  SORT 
      UNIQUE   19 
                                    
  TABLE ACCESS 
  PEOPLEASSIGNMENTS_POTOWNERS   BY INDEX ROWID   19 
                                        
  INDEX 
  FK1EE418D2C122ED2   RANGE SCAN   3 
                                            
  访问谓词 
                                                
  ORGANIZATI6_.ID=POTENTIALO9_.ENTITY_ID 
                                            
  过滤谓词 
                                                
  OR 
                                                    
  POTENTIALO9_.ENTITY_ID='chm.approver' 
                                                    
  POTENTIALO9_.ENTITY_ID='chm.operator' 
                                                    
  POTENTIALO9_.ENTITY_ID='chm.teamLeader' 
                                                    
  POTENTIALO9_.ENTITY_ID='ff8080813962106e0139628fcd28000e' 
                            
  INLIST ITERATOR 
            
                                
  TABLE ACCESS 
  TASK   BY INDEX ROWID   46 
                                    
  过滤谓词 
                                        
  AND 
                                            
  TASK0_.ARCHIVED=0 
                                            
  TASK0_.EXPIRATIONTIME IS NULL 
                                    
  INDEX 
  TASK_STATUS   RANGE SCAN   4 
                                        
  访问谓词 
                                            
  OR 
                                                
  TASK0_.STATUS='Created' 
                                                
  TASK0_.STATUS='InProgress' 
                                                
  TASK0_.STATUS='Ready' 
                                                
  TASK0_.STATUS='Reserved' 
                                                
  TASK0_.STATUS='Suspended' 
                        
  TABLE ACCESS 
  I18NTEXT   FULL   102 
                            
  过滤谓词 
                                
  NAMES5_.TASK_NAMES_ID(+) IS NOT NULL 
                    
  TABLE ACCESS 
  I18NTEXT   FULL   102 
                        
  过滤谓词 
                            
  SUBJECTS3_.TASK_SUBJECTS_ID(+) IS NOT NULL 
                
  TABLE ACCESS 
  I18NTEXT   FULL   102 
                    
  过滤谓词 
                        
  DESCRIPTIO4_.TASK_DESCRIPTIONS_ID(+) IS NOT NULL 
            
  SORT 
      AGGREGATE     
                
  INDEX 
  FK2349686B98B62B   RANGE SCAN   1 
                    
  访问谓词 
                        
  NAMES10_.TASK_NAMES_ID=:B1 
            
  SORT 
      AGGREGATE     
                
  INDEX 
  FK2349686BB2FA6B18   RANGE SCAN   1 
                    
  访问谓词 
                        
  SUBJECTS11_.TASK_SUBJECTS_ID=:B1 
            
  SORT 
      AGGREGATE     
                
  INDEX 
  FK2349686B69B21EE8   RANGE SCAN   1 
                    
  访问谓词 
                        
  DESCRIPTIO12_.TASK_DESCRIPTIONS_ID=:B1