Performance issue with TSP01.

[ronaldo_aparecido]

Good morning experts.

I changed the logic of a program called (ZCX_FEBRABANT)

wrote a logic:

DATA:t_zcaixa_loja TYPE TABLE OF zcaixa_loja,

          w_zcaixa_loja TYPE zcaixa_loja.

     SELECT SINGLE *

                   FROM zcaixa_loja

                   INTO w_zcaixa_loja

                   WHERE vkbur  =  t_loja-vkbur.

     IF sy-subrc = 0.

       CLEAR w_zcaixa_loja-seqp2k.

       w_zcaixa_loja-seqp2k = t_header-numseq.

       APPEND w_zcaixa_loja TO t_zcaixa_loja.

     ENDIF.

     IF NOT t_zcaixa_loja[] IS INITIAL.

       MODIFY zcaixa_loja FROM TABLE t_zcaixa_loja[].

       CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

         EXPORTING

           wait = 'X'.

     ENDIF.

He used EarlyWatchAlert-EWA report.

He also says:

We found that this table has two indexes, one of which consists of 3 columns and in one month it was not used once. The oracle loses time to do maintenance on the indexes after the inserts.

This is the index: TSP01 ~ A (table: TSP01). This index could be eliminated?

INSERT INTO "TSP01" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A11 ,:A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20 ,:A21 ,:A22 ,:A23 ,:A24 ,:A25 ,:A26 ,:A27 ,:A28 ,:A29 ,:A30 ,:A31 ,:A32 ,:A33 ,:A34 ,:A35 ,:A36 ,:A37 ,:A38 ,:A39 ,:A40 ,:A41 ,:A42 ,:A43 ,:A44 ,:A45 ,:A46 )

He says my ZCX_FEBRABANT program is consuming lot of resources Production server.

How can I check where my program is causing problems which tools should I use?

Thanks for help

[volker_borowski2]

So you have an overall of 9 physical reads on TSP01 !

This does not really fit with all the other values.

Based on the data given, I'd assume someone activated compression on that table,

which is a bad idea for TSP01.

If yes, do a reorg with brspace to turn off compression for this table.

Volker