Hi,
Is there any easy way to get rid of "faulty" Oracle hints hardcoded in standard LN?
I mean...I would like to let optimizer to choose correct path.

put
hint:nohint

in your db_resource.

it should turn off all hints.


Dave

Ok,
But that may not work in general. I would like to turn of all the index hints...

The only other hint baan might send is first_rows(#)

But, it's all or nothing, they don't have anything to give you fine grained
control.

Dave

From the Porting Set notes of 8.4b
DevDesprez: # 37923 (BDNT29924): Oracle driver crashs if ora_hint_no_hints is used
Date: Thu, 20 Dec 2007 14:20:06 +0100 (CET)
Created on: MaintChopin
Type: bugfix

Problem Description (Customer terms)
Use of resource variable ora_hint_no_hints resource crashs oracle database driver.

Workaround
Don't use ora_hint_no_hints resource.

Test Procedure
1 - Set ora_hint_no_hints:1 in %BSE%\lib\defaults\db_resource
2 - Run BW with command : ttaad2500m000

Affected Executables
ora8_srv