-
Notifications
You must be signed in to change notification settings - Fork 0
SqlServerTableHint
Mike King edited this page Sep 30, 2025
·
2 revisions
SQL Server Table Hints (used to override default query optimiser behaviour).
public sealed class SqlServerTableHint : DotDoc.EntityFrameworkCore.Extensions.TableHints.ITableHintInheritance System.Object 🡒 SqlServerTableHint
Implements ITableHint
| Fields | |
|---|---|
| ForceScan | FORCESCAN. |
| HoldLock | HOLDLOCK. |
| NoExpand | NOEXPAND. |
| NoLock | NOLOCK. |
| NoWait | NOWAIT. |
| PagLock | PAGLOCK. |
| ReadCommitted | READCOMMITTED. |
| ReadCommittedLock | READCOMMITTEDLOCK. |
| ReadPast | READPAST. |
| ReadUncommitted | READUNCOMMITTED. |
| RepeatableRead | REPEATABLEREAD. |
| RowLock | ROWLOCK. |
| Serializable | SERIALIZABLE. |
| Snapshot | SNAPSHOT. |
| TabLock | TABLOCK. |
| TabLockX | TABLOCKX. |
| Updlock | UPDLOCK. |
| XLock | XLOCK. |
| Methods | |
|---|---|
| ForceSeek() | FORCESEEK[( < index_value > ( < index_column_name > [ , ... ]))]. |
| ForceSeek(string, IEnumerable<string>) | FORCESEEK[( < index_value > ( < index_column_name > [ , ... ]))]. |
| Index(IEnumerable<string>) | INDEX( <index_value> [ , ...n] ) | INDEX = ( <index_value> ). |
| SpacialWindowMaxCells(int) | SPATIAL_WINDOW_MAX_CELLS = <integer_value>. |
| ToString() | Convert a table hint to a string. |