Home » RDBMS Server » Performance Tuning » Hidden parameter improve performance: _always_semi_join = FALSE
Hidden parameter improve performance: _always_semi_join = FALSE [message #65840] Mon, 10 January 2005 12:28
Narayan Venkat
Messages: 2
Registered: January 2005
Junior Member
All,

When I am working with a customer, we found a performance issue with a sun select Query. It's Oracle 9.2.0.5 and in CBO. The drivng table is not the correct table. There was some recommendation from Oracle saying we can set this hidden parameter _always_semi_join to FALSE and when we did the explain plan looks good and the performance improved.

My question to the experts, id there any risk to use this hidden parameters and any thought on this? Is it liable to advice to the customer to use this parameter? Any idea?

- Narayan
Previous Topic: how to connect with oracle database
Next Topic: Views or Tables?
Goto Forum:
  


Current Time: Sat Sep 19 01:16:53 CDT 2020