| slow insert statement [message #369574] |
Fri, 27 October 2000 03:16 |
pau de la cuesta
Messages: 1
Registered: October 2000
|
Junior Member |
|
|
Hi, can help me somebody about any slow insertion in a table; actual situation:
analyzed table with 3.008.296 rows
indexes:
index_1 over a field_1 whith 16.197 distincts rows.
index_2 over a field_2 whith 1.473 distincts rows.
TKPROFFed sentence:
INSERT INTO CASE_VARIABLE(TCID,VARIABLE,TYPE,RANK,VALUE,VISIBILITY)
VALUES(:b1,:b2,:b3,:b4,:b5,:b6)
call count cpu elapsed disk query current rows
-----------------------------------------------------
Parse 67 0.06 0.06 0 0 0 0
Execute 6066 2.86 6.27 515 180 43479 6066
Fetch 0 0.00 0.00 0 0 0 0
-----------------------------------------------------
total 6133 2.92 6.33 515 180 43479 6066
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 309 (W4)
Rows Execution Plan
-- ---------------------------------------------------
0 INSERT STATEMENT GOAL: CHOOSE
any comments, please...
Thanks in advance.
Pau del acuesta
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
