The optimizer cost is so high!!! WHY ????????
From: Bigfoot <ext6axp_at_ups.com>
Date: Wed, 17 Jan 2001 14:56:07 -0500
Message-ID: <944tcp$qm62_at_biko.telecom.ups.com>
Date: Wed, 17 Jan 2001 14:56:07 -0500
Message-ID: <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