Re: The optimizer cost is so high!!! WHY ????????
Date: Thu, 18 Jan 2001 16:17:50 -0500
Message-ID: <947mn0$96e1_at_biko.telecom.ups.com>
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.
Falco Paul wrote in message <946ld9$m15$1_at_azure.nl.gxn.net>... Post the optimizer plan so we can have a look at it. Falco
"Bigfoot" <ext6axp_at_ups.com> schreef in bericht
news:944tcp$qm62_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.
>
> Thanks
> Pushparaj
>
Received on Thu Jan 18 2001 - 22:17:50 CET