Operation	                                             Object Name	                  Rows	Bytes	Cost	
                                                                                                         
SELECT STATEMENT Hint=CHOOSE		                                                      2  	 	   1551  
  SORT ORDER BY		                                                                  2  	246  	1551  
    CONCATENATION		  	 	 	 	      	             	                                                
      FILTER		  	 	 	 	      	             	                                                   
        TABLE ACCESS BY INDEX ROWID	                        COM_POLICY_M	            1  	85  	3  	
          NESTED LOOPS		                                                            1  	85  	 	 	
            TABLE ACCESS BY INDEX ROWID	                  COM_POL_PROD_DTL	         1  	38  	3  	
              INDEX RANGE SCAN	                           COM_POLPROD_PRODSTAT	      1  	 	   3  	
            INDEX RANGE SCAN	                              XPKCOM_POLICY_M	         1  	 	   3  	
              TABLE ACCESS BY INDEX ROWID	                  PS_ALT_MAP	               1  	17  	3  	
                NESTED LOOPS		                                                      1  	50  	13  	
                  INLIST ITERATOR		  	 	 	 	      	             	                              
                    TABLE ACCESS BY INDEX ROWID	            PS_ALT_HDR	               1  	33  	10  	
                      INDEX RANGE SCAN	                     IDX_POLNBR_STAT	         11  	 	   4  	
                  INDEX RANGE SCAN	                        IDX_PAM_STRALTTRANSHDRNBR	1  	 	   3  	
      FILTER		  	 	 	 	      	             	                                                   
        NESTED LOOPS		                                                               1  	123  	5  	
          TABLE ACCESS BY INDEX ROWID	                     COM_POLICY_M	            1  	85  	3  	
            INDEX UNIQUE SCAN	                              XPKCOM_POLICY_M	         1  	 	   3  	
              TABLE ACCESS BY INDEX ROWID	                  PS_ALT_MAP	               1  	17  	3  	
                NESTED LOOPS		                                                      1  	50  	13  	
                  INLIST ITERATOR		  	 	 	 	      	             	                              
                    TABLE ACCESS BY INDEX ROWID	            PS_ALT_HDR	               1  	33  	10  	
                      INDEX RANGE SCAN	                     IDX_POLNBR_STAT	         11  	 	   4  	
                  INDEX RANGE SCAN	                        IDX_PAM_STRALTTRANSHDRNBR	1  	 	   3  	
          TABLE ACCESS BY INDEX ROWID	                     COM_POL_PROD_DTL	         1  	38  	3  	
            INDEX RANGE SCAN	                              INDX_CPPD_POLNBR	         1  	 	   3