Class OracleHints.Hint

Namespace

LinqToDB.DataProvider.Oracle

Assembly

linq2db.dll

public static class OracleHints.Hint

Inheritance

object

OracleHints.Hint

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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