Table of Contents

Class QueryStoreSchema.QueryStoreQueryHint

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.query_store_query_hints (Transact-SQL)

Applies to: √ Azure SQL Database √ Azure SQL Managed Instance

Contains query hints from the Query Store hints (Preview) feature.


See sys.query_store_query_hints.

[Table(Schema = "sys", Name = "query_store_query_hints", IsView = true)]
public class QueryStoreSchema.QueryStoreQueryHint
Inheritance
QueryStoreSchema.QueryStoreQueryHint
Extension Methods

Properties

Comment

Internal use only.

[Column("comment")]
[NotNull]
public string Comment { get; set; }

Property Value

string

LastQueryHintFailureReason

Error code returned when if applying hints failed. Will include the message_id of the error message.

[Column("last_query_hint_failure_reason")]
[NotNull]
public int LastQueryHintFailureReason { get; set; }

Property Value

int

LastQueryHintFailureReasonDesc

Will include the error description of the error message.

[Column("last_query_hint_failure_reason_desc")]
[NotNull]
public string LastQueryHintFailureReasonDesc { get; set; }

Property Value

string

QueryHintFailureCount

Number of times that the query hint application has failed since the query hint was created or last modified.

[Column("query_hint_failure_count")]
[NotNull]
public long QueryHintFailureCount { get; set; }

Property Value

long

QueryHintID

Unique identifier of a query hint.

[Column("query_hint_id")]
[NotNull]
public long QueryHintID { get; set; }

Property Value

long

QueryHintText

Hint definition in form of N'OPTION (…)

[Column("query_hint_text")]
[NotNull]
public string QueryHintText { get; set; }

Property Value

string

QueryID

Unique identifier of a query in the Query Store. Foreign key to sys.query_store_query.query_id.)

[Column("query_id")]
[NotNull]
public long QueryID { get; set; }

Property Value

long

Source

Source of Query Store hint: user source is zero and system-generated is non-zero.

[Column("source")]
[NotNull]
public int Source { get; set; }

Property Value

int

SourceDesc

Description of source of Query Store hint.

[Column("source_desc")]
[NotNull]
public string SourceDesc { get; set; }

Property Value

string