In a standard SAP transaction, there is the statement INSERT BKPF. The SQL trace shows this statement can take a long time to execute.
The oracle SQL is
SQL Statement ---------------------------------------------------------------------------------------------------------------------- INSERT INTO "BKPF" 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 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 ) Execution Plan ---------------------------------------------------------------------------------------------------------------------- System: xxx --------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------------- | 0 | INSERT STATEMENT | | 1 | 369 | 1 (0)| 00:00:01 | | 1 | LOAD TABLE CONVENTIONAL | BKPF | | | | | --------------------------------------------------------------------------------- Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - INS$1
Could a badly defined index causing an INSERT performance problem? Obviously, adding an index increases the time taken to process an insert, but it couldn't cause actual performance problems, could i?
Edited by: Matt on Feb 14, 2011 11:54 AM