This topic has not yet been rated - Rate this topic

SelectiveXmlIndexPromotedPath.IsSingleton Property

SQL Server 2012

Gets or sets a value that indicates whether ‘SINGLETON’ optimization hint is applied for the given XML path.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

public bool IsSingleton { get; set; }

Property Value

Type: System.Boolean
true if ‘SINGLETON’ optimization hint is applied for the given XML path; otherwise, false.

Reference

SelectiveXmlIndexPromotedPath Class

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD