Table of Contents

Class OracleHints.Hint

Namespace
LinqToDB.DataProvider.Oracle
Assembly
linq2db.dll
public static class OracleHints.Hint
Inheritance
OracleHints.Hint

Fields

AllRows 

public const string AllRows = "ALL_ROWS"

Field Value

string

Append 

public const string Append = "APPEND"

Field Value

string

AppendValues 

public const string AppendValues = "APPEND_VALUES"

Field Value

string

Cache 

public const string Cache = "CACHE"

Field Value

string

Cluster 

public const string Cluster = "CLUSTER"

Field Value

string

Clustering 

public const string Clustering = "CLUSTERING"

Field Value

string

CursorSharingExact 

public const string CursorSharingExact = "CURSOR_SHARING_EXACT"

Field Value

string

DisableParallelDml 

public const string DisableParallelDml = "DISABLE_PARALLEL_DML"

Field Value

string

DrivingSite 

public const string DrivingSite = "DRIVING_SITE"

Field Value

string

DynamicSampling 

public const string DynamicSampling = "DYNAMIC_SAMPLING"

Field Value

string

EnableParallelDml 

public const string EnableParallelDml = "ENABLE_PARALLEL_DML"

Field Value

string

Fact 

public const string Fact = "FACT"

Field Value

string

FreshMV 

public const string FreshMV = "FRESH_MV"

Field Value

string

FreshMaterializedView 

public const string FreshMaterializedView = "FRESH_MV"

Field Value

string

Full 

public const string Full = "FULL"

Field Value

string

Grouping 

public const string Grouping = "GROUPING"

Field Value

string

Hash 

public const string Hash = "HASH"

Field Value

string

InMemory 

public const string InMemory = "NMEMORY"

Field Value

string

InMemoryPruning 

public const string InMemoryPruning = "INMEMORY_PRUNING"

Field Value

string

Index 

public const string Index = "INDEX"

Field Value

string

IndexAsc 

public const string IndexAsc = "INDEX_ASC"

Field Value

string

IndexCombine 

public const string IndexCombine = "INDEX_COMBINE"

Field Value

string

IndexDesc 

public const string IndexDesc = "INDEX_DESC"

Field Value

string

IndexFFS 

public const string IndexFFS = "INDEX_FFS"

Field Value

string

IndexFastFullScan 

public const string IndexFastFullScan = "INDEX_FFS"

Field Value

string

IndexJoin 

public const string IndexJoin = "INDEX_JOIN"

Field Value

string

IndexSS 

public const string IndexSS = "INDEX_SS"

Field Value

string

IndexSSAsc 

public const string IndexSSAsc = "INDEX_SS_ASC"

Field Value

string

IndexSSDesc 

public const string IndexSSDesc = "INDEX_SS_DESC"

Field Value

string

IndexSkipScan 

public const string IndexSkipScan = "INDEX_SS"

Field Value

string

IndexSkipScanAsc 

public const string IndexSkipScanAsc = "INDEX_SS_ASC"

Field Value

string

IndexSkipScanDesc 

public const string IndexSkipScanDesc = "INDEX_SS_DESC"

Field Value

string

Leading 

public const string Leading = "LEADING"

Field Value

string

Merge 

public const string Merge = "MERGE"

Field Value

string

ModelMinAnalysis 

public const string ModelMinAnalysis = "MODEL_MIN_ANALYSIS"

Field Value

string

Monitor 

public const string Monitor = "MONITOR"

Field Value

string

NativeFullOuterJoin 

public const string NativeFullOuterJoin = "NATIVE_FULL_OUTER_JOIN"

Field Value

string

NoAppend 

public const string NoAppend = "NOAPPEND"

Field Value

string

NoCache 

public const string NoCache = "NOCACHE"

Field Value

string

NoClustering 

public const string NoClustering = "NO_CLUSTERING"

Field Value

string

NoExpand 

public const string NoExpand = "NO_EXPAND"

Field Value

string

NoFact 

public const string NoFact = "NO_FACT"

Field Value

string

NoInMemory 

public const string NoInMemory = "NO_INMEMORY"

Field Value

string

NoInMemoryPruning 

public const string NoInMemoryPruning = "NO_INMEMORY_PRUNING"

Field Value

string

NoIndex 

public const string NoIndex = "NO_INDEX"

Field Value

string

NoIndexFFS 

public const string NoIndexFFS = "NO_INDEX_FFS"

Field Value

string

NoIndexFastFullScan 

public const string NoIndexFastFullScan = "NO_INDEX_FFS"

Field Value

string

NoIndexSS 

public const string NoIndexSS = "NO_INDEX_SS"

Field Value

string

NoIndexSkipScan 

public const string NoIndexSkipScan = "NO_INDEX_SS"

Field Value

string

NoMerge 

public const string NoMerge = "NO_MERGE"

Field Value

string

NoMonitor 

public const string NoMonitor = "NO_MONITOR"

Field Value

string

NoNativeFullOuterJoin 

public const string NoNativeFullOuterJoin = "NO_NATIVE_FULL_OUTER_JOIN"

Field Value

string

NoPQConcurrentUnion 

public const string NoPQConcurrentUnion = "NO_PQ_CONCURRENT_UNION"

Field Value

string

NoPQSkew 

public const string NoPQSkew = "NO_PQ_SKEW"

Field Value

string

NoParallel 

public const string NoParallel = "NO_PARALLEL"

Field Value

string

NoParallelIndex 

public const string NoParallelIndex = "NO_PARALLEL_INDEX"

Field Value

string

NoPushPredicate 

public const string NoPushPredicate = "PUSH_PRED"

Field Value

string

NoPushSubQueries 

public const string NoPushSubQueries = "NO_PUSH_SUBQ"

Field Value

string

NoPxJoinFilter 

public const string NoPxJoinFilter = "NO_PX_JOIN_FILTER"

Field Value

string

NoQueryTransformation 

public const string NoQueryTransformation = "NO_QUERY_TRANSFORMATION"

Field Value

string

NoRewrite 

public const string NoRewrite = "NO_REWRITE"

Field Value

string

NoStarTransformation 

public const string NoStarTransformation = "NO_STAR_TRANSFORMATION"

Field Value

string

NoUnnest 

public const string NoUnnest = "NO_UNNEST"

Field Value

string

NoUseBand 

public const string NoUseBand = "NO_USE_BAND"

Field Value

string

NoUseCube 

public const string NoUseCube = "NO_USE_CUBE"

Field Value

string

NoUseHash 

public const string NoUseHash = "NO_USE_HASH"

Field Value

string

NoUseMerge 

public const string NoUseMerge = "NO_USE_MERGE"

Field Value

string

NoUseNL 

public const string NoUseNL = "NO_USE_NL"

Field Value

string

NoUseNestedLoop 

public const string NoUseNestedLoop = "NO_USE_NL"

Field Value

string

NoXmlIndexRewrite 

public const string NoXmlIndexRewrite = "NO_XMLINDEX_REWRITE"

Field Value

string

NoXmlQueryRewrite 

public const string NoXmlQueryRewrite = "NO_XML_QUERY_REWRITE"

Field Value

string

OptParam 

public const string OptParam = "OPT_PARAM"

Field Value

string

Ordered 

public const string Ordered = "ORDERED"

Field Value

string

PQConcurrentUnion 

public const string PQConcurrentUnion = "PQ_CONCURRENT_UNION"

Field Value

string

PQDistribute 

public const string PQDistribute = "PQ_DISTRIBUTE"

Field Value

string

PQFilterHash 

public const string PQFilterHash = "PQ_FILTER(HASH)"

Field Value

string

PQFilterNone 

public const string PQFilterNone = "PQ_FILTER(NONE)"

Field Value

string

PQFilterRandom 

public const string PQFilterRandom = "PQ_FILTER(RANDOM)"

Field Value

string

PQFilterSerial 

public const string PQFilterSerial = "PQ_FILTER(SERIAL)"

Field Value

string

PQSkew 

public const string PQSkew = "PQ_SKEW"

Field Value

string

Parallel 

public const string Parallel = "PARALLEL"

Field Value

string

ParallelIndex 

public const string ParallelIndex = "PARALLEL_INDEX"

Field Value

string

PushPredicate 

public const string PushPredicate = "PUSH_PRED"

Field Value

string

PushSubQueries 

public const string PushSubQueries = "PUSH_SUBQ"

Field Value

string

PxJoinFilter 

public const string PxJoinFilter = "PX_JOIN_FILTER"

Field Value

string

Rewrite 

public const string Rewrite = "REWRITE"

Field Value

string

StarTransformation 

public const string StarTransformation = "STAR_TRANSFORMATION"

Field Value

string

Unnest 

public const string Unnest = "UNNEST"

Field Value

string

UseBand 

public const string UseBand = "USE_BAND"

Field Value

string

UseConcat 

public const string UseConcat = "USE_CONCAT"

Field Value

string

UseCube 

public const string UseCube = "USE_CUBE"

Field Value

string

UseHash 

public const string UseHash = "USE_HASH"

Field Value

string

UseMerge 

public const string UseMerge = "USE_MERGE"

Field Value

string

UseNL 

public const string UseNL = "USE_NL"

Field Value

string

UseNLWithIndex 

public const string UseNLWithIndex = "USE_NL_WITH_INDEX"

Field Value

string

UseNestedLoop 

public const string UseNestedLoop = "USE_NL"

Field Value

string

UseNestedLoopWithIndex 

public const string UseNestedLoopWithIndex = "USE_NL_WITH_INDEX"

Field Value

string

Methods

Containers(string) 

[Sql.Expression("CONTAINERS(DEFAULT_PDB_HINT='{0}')")]
public static string Containers(string hint)

Parameters

hint string

Returns

string

FirstRows(int) 

[Sql.Expression("FIRST_ROWS({0})")]
public static string FirstRows(int value)

Parameters

value int

Returns

string