SqlHints Class

Provides SQL hints

Inheritance Hierarchy

System.Object
  CMS.DataEngine.SqlHints

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0

Syntax

public class SqlHints

The SqlHints type exposes the following members.

Constructors

	Name	Description
Public method	SqlHints

Fields

	Name	Description
Public field Static member	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 field Static member	NOLOCK	Specifies that the query can read the uncommitted data and ignores the locks.

Methods

	Name	Description
Public method Static member	GetTableHints	Gets the table hints for the query