Re: HINTS Problem

In article <350DEEFA.8679FFC6_at_vdoj.vic.gov.au>, Andy Horne <sysadmin_at_vdoj.vic.gov.au> wrote:
>I have a query which has HINTS in it which is causing problems:
>
>I have 2 databases, one V7.1.6 on SVR4 (Pyramid Nile) and the other
>V7.3.2 on Solaris 2.5.1. The V7.3.2 database is a copy of the V7.1.6
>one.
>
>The application runs a query which has hints in it. When it runs on the
>V7.1.6 database there is no problem (does a select by rowid), but when
>it runs on the V7.3.2 database it does a full table scan.
>The databases are identical as far as initialisation parameters are
>concerned, so I suspect that there is a change in the Optimizer causing
>the problem. If I remove the HINT then the query runs OK (ROWID), but
>the programmer doesn't want to have to change the code.
>
>Does anybody have any ideas? I've tried setting hash_join_enabled =
>false but this had no effect.

I had a similar problem, I think there are still bugs in the optimizer. Fortunately, my programmer was willing to change the code so it works. Unfortunately, I was not willing to put more time into proving the bug.

>
>TIA,
>
>Andy Horne
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!