QUERY: (OPTIMIZATION TIMESTAMP:  04 - 08 - 2009   11 : 50 : 59 )        (FIRST_ROWS OPTIMIZATION)

------
SELECT {+ EXPLAIN }
    id_account_db
  , id_account_kr
  , SUM(NVL(db_sum_nat, 0 )) AS td_nat
  , SUM(NVL(kr_sum_nat, 0 )) AS tk_nat
  FROM sm_posting
    WHERE (type_post >=  3 )
      AND (post_date BETWEEN MDY( 3 ,  1 ,  2009 ) AND MDY( 3 ,  31 ,  2009 ))
      AND (
           (id_account_db =  93421 )
        OR
           (id_account_kr =  93421 )
      )
  GROUP BY
    id_account_db, id_account_kr

DIRECTIVES FOLLOWED:
EXPLAIN

Estimated Cost:  184 
Estimated # of Rows Returned:  24 
Temporary Files Required For: Group By

   1 ) informix.sm_posting: INDEX PATH

    ( 1 ) Index Keys: id_account_db post_date   (Key-First)  (Serial, fragments: ALL)
        Lower Index Filter: (informix.sm_posting.id_account_db =  93421  AND informix.sm_posting.post_date >=  01 . 03 . 2009  )
        Upper Index Filter: informix.sm_posting.post_date <=  31 . 03 . 2009 
        Index Key Filters:  (informix.sm_posting.post_date <=  31 . 03 . 2009  )

    ( 2 ) Index Keys: id_account_kr post_date   (Key-First)  (Serial, fragments: ALL)
        Lower Index Filter: (informix.sm_posting.id_account_kr =  93421  AND informix.sm_posting.post_date >=  01 . 03 . 2009  )
        Upper Index Filter: informix.sm_posting.post_date <=  31 . 03 . 2009 
        Index Key Filters:  (informix.sm_posting.post_date <=  31 . 03 . 2009  )

Query statistics:
-----------------

  Table map :
  ----------------------------
  Internal name     Table name
  ----------------------------
  t1                sm_posting

  type     table  rows_prod  est_rows  rows_scan  time       est_cost
  -------------------------------------------------------------------
  scan     t1      306          113         306          00 : 00 . 00     185 

  type     rows_prod  est_rows  rows_cons  time
  -------------------------------------------------
  group     5            24          306          00 : 00 . 00