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.
[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
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
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
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
QueryHintID
Unique identifier of a query hint.
[Column("query_hint_id")]
[NotNull]
public long QueryHintID { get; set; }
Property Value
QueryHintText
Hint definition in form of N'OPTION (…)
[Column("query_hint_text")]
[NotNull]
public string QueryHintText { get; set; }
Property Value
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
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
SourceDesc
Description of source of Query Store hint.
[Column("source_desc")]
[NotNull]
public string SourceDesc { get; set; }