Re: The optimizer cost is so high!!! WHY ????????
From: Eric Friedman <efried_at_bellsouth.net>
Date: Thu, 18 Jan 2001 04:23:10 GMT
Message-ID: <xcu96.3398$1s1.154618_at_news4.atl>
Eric Friedman Internet: efried_at_bellsouth.net Received on Thu Jan 18 2001 - 05:23:10 CET
Date: Thu, 18 Jan 2001 04:23:10 GMT
Message-ID: <xcu96.3398$1s1.154618_at_news4.atl>
How many indexes are there.
Eric
In article <944tcp$qm62biko.telecom.ups.com>, "Bigfoot" <ext6axp_at_ups.com>
wrote:
>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
>
Eric Friedman Internet: efried_at_bellsouth.net Received on Thu Jan 18 2001 - 05:23:10 CET