CREATE UNIQUE INDEX rb_call_activities_u1
ON rb_call_activities(tape_id,record_id)
storage (initial 50m next 50m pctincrease 0)
parallel (degree 4)
tablespace rb_index02
/
CREATE INDEX rb_call_activities_n2
ON rb_call_activities(tape_id,pre_status)
storage (initial 50m next 50m pctincrease 0)
parallel (degree 4)
tablespace rb_index02
/
CREATE INDEX rb_call_activities_n3
ON rb_call_activities(account_id)
storage (initial 50m next 50m pctincrease 0)
parallel (degree 4)
tablespace rb_index02
/
CREATE INDEX rb_call_activities_n4
ON rb_call_activities(billing_batch_id,account_id,agreement_id)
storage (initial 50m next 50m pctincrease 0)
parallel (degree 4)
tablespace rb_index02
/
COMMIT;