Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSERT TAKES 27 Milliseconds

296002Sep 3 2002
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)
################################################################
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2002
Added on Sep 3 2002
6 comments
631 views