Home -> Usenet -> comp.databases.oracle -> Optimizer problems 7.0.16.4, Solaris

Optimizer problems 7.0.16.4, Solaris

From: 25994-kelly <mjk_at_spanky.cc.bellcore.com>
Date: 15 Nov 1994 19:42:34 GMT
Message-ID: <3ab2va$mc3_at_athos.cc.bellcore.com> 






Has anyone else had problems with the optimizer on 7.0.16.4?
I get completely different plans for the same query on the same data
seemingly at random. The data and the table statistics do not change but the plan does. One plan takes 1 minute. The other takes 10 minutes and involves
reading both involved tables with full scans 3 times each. It is the worst
imaginable way to satisfy the query. I have opened a problem with Oracle
about this but they seem to think I should just change to 7.1 because
they put fixes into 7.1. I can't do this easily because our product is
built on a workstation factory environment and I have to get those folks
to test/approve it for many applications before I can use it.
Received on Tue Nov 15 1994 - 20:42:34 CET












Original text of this message