Re: Performance problems during INSERTs and OPTIMIZER

From: <toneczar_at_erols.com>
Date: Thu, 21 Jan 1999 14:17:02 GMT
Message-ID: <787csl$hh9$1@nnrp1.dejanews.com>

riad_at_innocent.ANTI-SPAM.ORG wrote:

> ... the OPTIMIZER seems to prefer taking into account EXPLAIN PLANS
> that have costs a lot higher than some others (when I force /*+ index(table
> index)*/ ...

Have you tried setting the optimizer_goal to "RULE" for that session or using the /*+ RULE */ hint? That may make a dramatic difference in this case.

Chris

---

Chris Hamilton -- toneczar_at_erols.com
http://www.serve.com/cowpb/chamilton.html City of Washington Pipe Band

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 21 1999 - 08:17:02 CST