The optimizer cost is so high!!! WHY ????????
From: Bigfoot <ext6axp_at_ups.com>
Date: Thu, 18 Jan 2001 16:25:04 -0500
Message-ID: <947n4i$96e2_at_biko.telecom.ups.com>
INSERT STATEMENT Cost = 289302
Date: Thu, 18 Jan 2001 16:25:04 -0500
Message-ID: <947n4i$96e2_at_biko.telecom.ups.com>
I am running a simple insert statement in my production database and I find that the optimizer cost is 289,302. The table already has 300+ million rows. Could any one please tell me is there anyway to improve this table and reduce the cost.
EXPLAIN PLAN SET STATEMENT_ID = 'ACCT_PLN' FOR
insert into hsacct
(act_nr,gng_nr,val_cd,typ_cd,wmk_cd,pln_nr,zng_cd,wgt_typ,com_cd,
llp_typ,dmo_cd,val_cd)
values (:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12)
/
Query Plan
INSERT STATEMENT Cost = 289302
The table has 1 unique concatenated index on 6 columns.
Thanks
Pushparaj
Received on Thu Jan 18 2001 - 22:25:04 CET