INSERT TAKES 27 Milliseconds
My Insert statement takes about 27 Milliseconds to execute what can be done to improve it...
Right now there are two index on it
Unique index (pr_code,pr_value)
Index by code
Please help
Regards
Mahesh
################################################################
INSERT INTO product(product_id, pr_code, pr_value)
VALUES
(:1,:2,:3)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 34 0.01 0.02 0 0 0 0
Execute 294 0.23 0.25 1 35 2091 294
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 328 0.24 0.27 1 35 2091 294
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20 (SECFINBUILD3)
################################################################