| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
