Class SqlHints

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Provides SQL hints

public class SqlHints

Inheritance

object

SqlHints

Extension Methods

DataExtensions.With<T>(T, Action<T>)

QueryExtensions.AsLiteral<T>(T)

QueryExtensions.AsValue<T>(T, bool)

Fields

NOEXPAND

Specifies that any indexed views are not expanded to access underlying tables when the query optimizer processes the query. The query optimizer treats the view like a table with clustered index. NOEXPAND applies only to indexed views.

public const string NOEXPAND = "NOEXPAND"

Field Value

string

NOLOCK

Specifies that the query can read the uncommitted data and ignores the locks.

public const string NOLOCK = "NOLOCK"

Field Value

string

Methods

GetTableHints(params string[])

Gets the table hints for the query

public static string GetTableHints(params string[] hints)

Parameters

hints string[]

List of hints to include

Returns

string