SELECT /*+ index(a_adjustment_audit.a_adj_audit_pk) */
              audit_metadata_1 ticket_no,
               audit_metadata_2 original_trade_reference,
               audit_metadata_3 trade_id,
               row_number() over (order by row_created_dttm asc) version_no,
               audit_user_id user_id,
               team team,
               row_created_dttm row_created_dttm,
               TO_NUMBER(audit_metadata_4) original_value,
               TO_NUMBER(audit_metadata_5) current_value,
               TO_NUMBER(audit_metadata_5) - TO_NUMBER(audit_metadata_4) adjusted_value,
               adjustment_comment adjustment_comment,
               fs.sensitivity_type_code sensitivity_type
          FROM a_adjustment_audit aud INNER JOIN f_sensitivity fs ON (aud.row_bridge_key = fs.sensitivity_key)
         WHERE aud.table_name = 'F_SENSITIVITY' AND
               aud.row_bridge_key = 1816094285 AND
               ROWNUM < 1001

SELECT STATEMENT, GOAL = ALL_ROWS			1510	1	135
 WINDOW NOSORT			1510	1	135
  COUNT STOPKEY					
   MERGE JOIN CARTESIAN			1509	1	135
    TABLE ACCESS BY INDEX ROWID	CRIS_WAREHOUSE_USER	A_ADJUSTMENT_AUDIT	2	1	118
     INDEX RANGE SCAN	CRIS_WAREHOUSE_USER	A_ADJ_AUDIT_PK	1	1	
    BUFFER SORT			1508	1	17
     PARTITION LIST ALL			1507	1	17
      PARTITION LIST ALL			1507	1	17
       INDEX SKIP SCAN	CRIS_WAREHOUSE_USER	F_SENSITIVITY_PK	1507	1	17