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

When I am working with a customer, we found a performance issue with a sun select Query. It's Oracle 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: Thu Feb 29 22:44:58 CST 2024