Re: Where can I get a complete list of all SQL Hints?

hi from Paris

For a list of supported, and explaination of optimizer hints, RTFM:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#8326

Others hints won't be documented because they are not supported. For example, you spoke of 'bypass_recursive_check', wich is a workaround for bug 1816154.

They should only be used under direction by Oracle Support, because they are only useful in order to change optimizer default action, and so for several reasons. But they can rarely be used for performance purpose.

Don't think you can be more intelligent than Oracle people, by using beta features with hidden events, or using unsupported configurations.

And don't cry after having losed your unsupported production database...

"Geomancer" <pharfromhome_at_hotmail.com> a écrit dans le message de news:cf90fb89.0306140419.322f281_at_posting.google.com...
> If the CBO is so great, why all the hints?
>
> Also, any ideas or tips for using the undocumented hints?
>
>
> BYPASS_RECURSIVE_CHECK
> BYPASS_UJVC
> CACHE_CB
> CACHE_TEMP_TABLE
> CIV_GB
> COLLECTIONS_GET_REFS
> CUBE_GB
> CURSOR_SHARING_EXACT
> DEREF_NO_REWRITE
> DML_UPDATE
> DOMAIN_INDEX_NO_SORT
> DOMAIN_INDEX_SORT
> DYNAMIC_SAMPLING
> DYNAMIC_SAMPLING_EST_CDN
> EXPAND_GSET_TO_UNION
> FORCE_SAMPLE_BLOCK
> GBY_CONC_ROLLUP
> GLOBAL_TABLE_HINTS
> HWM_BROKERED
> IGNORE_ON_CLAUSE
> IGNORE_WHERE_CLAUSE
> INDEX_RRS
> INDEX_SS
> INDEX_SS_ASC
> INDEX_SS_DESC
> LIKE_EXPAND
> LOCAL_INDEXES
> MV_MERGE
> NESTED_TABLE_GET_REFS
> NESTED_TABLE_SET_REFS
> NESTED_TABLE_SET_SETID
> NO_EXPAND_GSET_TO_UNION
> NO_FACT
> NO_FILTERING
> NO_ORDER_ROLLUPS
> NO_PRUNE_GSETS
> NO_STATS_GSETS
> NO_UNNEST
> NOCPU_COSTING
> OVERFLOW_NOMOVE
> PIV_GB
> PIV_SSF
> PQ_MAP
> PQ_NOMAP
> REMOTE_MAPPED
> RESTORE_AS_INTERVALS
> SAVE_AS_INTERVALS
> SCN_ASCENDING
> SKIP_EXT_OPTIMIZER
> SQLLDR
> SYS_DL_CURSOR
> SYS_PARALLEL_TXN
> SYS_RID_ORDER
> TIV_GB
> TIV_SSF
> UNNEST
> USE_TTT_FOR_GSETS
Received on Sat Jun 14 2003 - 11:41:05 CDT