Select t.cAccSerno, t.i051_cur_bill, Sum(t.Amount), Count(*)
 From cTransactions t
 Where t.Orig_Msg_Type In ('CRSTL', 'DBSTL')
 Group By  1 , 2 

QUERY:
------
Select {+explain} t.cAccSerno, t.i051_cur_bill, Sum(t.Amount), Count(*)
 From cTransactions t
 Where t.Orig_Msg_Type In ('CRSTL', 'DBSTL')
 Group By  1 , 2 

DIRECTIVES FOLLOWED: 
EXPLAIN 
DIRECTIVES NOT FOLLOWED: 

Estimated Cost:  71400 
Estimated # of Rows Returned:  17 
Temporary Files Required For: Group By

   1 ) informix.t: SEQUENTIAL SCAN  (Serial, fragments: ALL)

        Filters: informix.t.orig_msg_type IN ('CRSTL' , 'DBSTL' )

create index "cap".ctrxns03 on "cap".ctransactions (batchserno) 
    using btree ;
create index "cap".ctrxns04 on "cap".ctransactions (postdate) 
    using btree ;
create index "cap".ctrxns05 on "cap".ctransactions (posttimestamp) 
    using btree ;
create index "cap".ctrxns06 on "cap".ctransactions (stgeneral) 
    using btree ;
create index "cap".ctrxnsi01 on "cap".ctransactions (caccserno) 
    using btree ;
create index "cap".ctrxnsi02 on "cap".ctransactions (cardserno) 
    using btree ;
create unique index "cap".ctrxnsui01 on "cap".ctransactions (serno) 
    using btree ;
alter table "cap".ctransactions add constraint primary key (serno) 
    constraint "cap".ctrxnspk