Create Index

Description: Samples of index creation.

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;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.