SELECT t.tx_date txdate, t.tx_serial, m.merchant_id, b.branch_id,
  2         s.mobile_number beneficiary_no, t.tx_type, t.tx_status, t.point_value,
  3         t.tx_rupee_value, t.bill_value, t.bill_number,
       c.mobile_number counter_no, t.redemption_commission
  4    5    FROM rs_transaction_2008_jan t,
  6         rs_merchant_info m,
       rs_merch_branch b,
       rs_merch_counter c,
       rs_subscriber s
  7    8    9   10   WHERE t.merchent_counter_id = c.counter_id
 11     AND c.branch_id = b.branch_id
 12     AND b.merchant_id = m.merchant_id
   AND t.subscriber_id = s.subscriber_id
 13   14  /

Execution Plan
----------------------------------------------------------
Plan hash value: 3505644035

--------------------------------------------------------------------------------
-------------------------

| Id  | Operation             | Name                    | Rows  | Bytes |TempSpc
| Cost (%CPU)| Time     |

--------------------------------------------------------------------------------
-------------------------

|   0 | SELECT STATEMENT      |                         |  8280K|   750M|
| 53762   (3)| 00:10:46 |

|*  1 |  HASH JOIN            |                         |  8280K|   750M|
| 53762   (3)| 00:10:46 |

|   2 |   INDEX FULL SCAN     | PK_RS_MERCHANT_INFO     |   130 |   520 |
|     1   (0)| 00:00:01 |

|*  3 |   HASH JOIN           |                         |  8280K|   718M|
| 53664   (2)| 00:10:44 |

|   4 |    TABLE ACCESS FULL  | RS_MERCH_BRANCH         |   475 |  3800 |
|     5   (0)| 00:00:01 |

|*  5 |    HASH JOIN          |                         |  8280K|   655M|
| 53562   (2)| 00:10:43 |

|   6 |     TABLE ACCESS FULL | RS_MERCH_COUNTER        |  1457 | 33511 |
|     6   (0)| 00:00:01 |

|*  7 |     HASH JOIN         |                         |  8280K|   473M|    97M
| 53460   (2)| 00:10:42 |

|   8 |      TABLE ACCESS FULL| RS_SUBSCRIBER           |  3652K|    55M|
| 11025   (2)| 00:02:13 |

|   9 |      TABLE ACCESS FULL| RS_TRANSACTION_2008_JAN |  8280K|   347M|
| 15399   (4)| 00:03:05 |

--------------------------------------------------------------------------------
-------------------------


Predicate Information (identified by operation id):
---------------------------------------------------

   1 - access("B"."MERCHANT_ID"="M"."MERCHANT_ID")
   3 - access("C"."BRANCH_ID"="B"."BRANCH_ID")
   5 - access("T"."MERCHENT_COUNTER_ID"="C"."COUNTER_ID")
   7 - access("T"."SUBSCRIBER_ID"="S"."SUBSCRIBER_ID")

SQL>