How can I have COST = 2419 for an INSERT statement?

From: Syltrem <syltrem_at_videotron.ca.spammenot>
Date: Thu, 30 Aug 2001 10:17:07 -0400
Message-ID: <aUrj7.56840$TW.298321@tor-nn1.netcom.ca>

I have this INSERT statement, with no imbedded select, that has a cost of 2419. How is this possible?
INSERT INTO FINANCE.SALES_ORDER_LINES
(COMPANY_CODE,DIVISION,ORDER_NUMBER,ORDER_LINE_NUMBER,ORDER_LINE_TYPE, ........

,IFA_WH_FOR_ORDER_TYPE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9


,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25

,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41

,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57

,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,:68,:69,:70,:71,:72,:73
,:74,:75,:76) RETURNING rowid INTO :rid

The table has 4 indexes, each made of 5 or 6 columns.

Additionnal info: I already set up an DBMS_SYSTEM.SET_EV for event 10053 for the running job, but it has a lot of rows to process and I do not know of a way to stop the tracing before the job completes so I do not have the results yet in the trace file.

Thanks!

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site)

Received on Thu Aug 30 2001 - 09:17:07 CDT