Click or drag to resize

HintEnum Fields

The HintEnum type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberDISABLE_OUTPUTLIMIT_OPT
For use with output rate limiting.
Public fieldStatic memberDISABLE_RECLAIM_GROUP
For use with group-by, disabled reclaim groups.
Public fieldStatic memberDISABLE_UNIQUE_IMPLICIT_IDX
For use everywhere where unique data window are used
Public fieldStatic memberDISABLE_WHEREEXPR_MOVETO_FILTER
For use everywhere where unique data window are used
Public fieldStatic memberDISABLE_WINDOW_SUBQUERY_INDEXSHARE
If ENABLE_WINDOW_SUBQUERY_INDEXSHARE is not specified for a named window (the default) then this instruction is ignored.

For use with statements that subquery a named window and that benefit from a statement-local data structure representing named window contents (table, index), maintained through consuming the named window insert and remove stream.

Public fieldStatic memberENABLE_OUTPUTLIMIT_OPT
For use with output rate limiting.
Public fieldStatic memberENABLE_WINDOW_SUBQUERY_INDEXSHARE
For use with create-named-window statements only, to indicate that statements that subquery the named window use named window data structures (unless the subquery statement specifies below DISBABLE hint and as listed below).

By default and if this hint is not specified or subqueries specify a stream filter on a named window, subqueries use statement-local data structures representing named window contents (table, index). Such data structure is maintained by consuming the named window insert and remove stream.

Public fieldStatic memberEXCLUDE_PLAN
For use where query planning applies.
Public fieldStatic memberFORCE_NESTED_ITER
For use with join query plans to force a nested iteration plan.
Public fieldStatic memberINDEX
For use everywhere where indexes are used (subquery, joins, fire-and-forget, on-select etc.), index hint.
Public fieldStatic memberITERATE_ONLY
For use with match_recognize, iterate-only matching.
Public fieldStatic memberMAX_FILTER_WIDTH
For use when filter expression optimization may widen the filter expression
Public fieldStatic memberPREFER_MERGE_JOIN
For use with join query plans to indicate preferance of the merge-join query plan.
Public fieldStatic memberRECLAIM_GROUP_AGED
For use with group-by and std:groupwin, reclaim groups for unbound streams based on time. The number of seconds after which a groups is reclaimed if inactive.
Public fieldStatic memberRECLAIM_GROUP_FREQ
For use with group-by and std:groupwin, reclaim groups for unbound streams based on time, this number is the frequency in seconds at which a sweep occurs for aged groups, if not provided then the sweep frequency is the same number as the age.
Public fieldStatic memberSET_NOINDEX
For use with subqueries and on-select, on-merge, on-Update and on-delete to specify the query engine neither build an implicit index nor use an existing index, always performing a full table scan.
Public fieldvalue__
Top
See Also