Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: statement tuning ?
>Officially, the vendor's policy is that these are not to be changed,
>however, I've had some success using outlines to elicit different
>behaviors for queries of this type.
>
>Try entering an outline with the USE_HASH index hint.
Note though, that this will require that Object statistics be collected. If CBO is 'forced' because of the use of Outlines, and there are no stats on the tables involved, CBO assumes a set of statistics that are ridiculous. For the default values, check the Performance Tuning Guide!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com
![]() |
![]() |