1 Reply Latest reply: Jul 12, 2012 5:58 AM by 874539 RSS

    Index Compression Questions

    874539
      HI All,

      I need some your valuable answer for question as below.. before that I want to say we are using Oracle 11(11.2.0.2) in our SAP landscape.

      1.How we can check large index that we can compress?

      2.How to check all Index name at once that we need to compress?

      3.How much compression degree (examples 1,4,7,8) we can set for index compression, or how we know it?

      4.Is there a ways to make a package with the help of we can compress all index ?

      Just an examples that actual I am looking for

      alter index "SAPSR3"."EBAN~1" rebuild compress 5 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~1" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."EBAN~2" rebuild compress 5 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~2" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."EBAN~3" rebuild compress 4 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~3" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."EBAN~4" rebuild compress 2 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~4" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."EBAN~B" rebuild compress 2 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~B" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."EBAN~SRV" rebuild compress 2 parallel 4 pctfree 1;
      alter index "SAPSR3"."EBAN~SRV" noparallel;
      ---------------------------------------
      alter index "SAPSR3"."SOC3~0" rebuild compress 2 parallel 4 pctfree 1;
      alter index "SAPSR3"."SOC3~0" noparallel;
      ---------------------------------------

      Thanks
      RR