SQL Server enforces the use of specific indexes, degrees of parallelism

SQL Server enforces the use of specific indexes, degrees of parallelism

Back up before modifying or deleting data, back up first, back up (important things say three times)

Most of the time you may want to test, perhaps in order to avoid the concurrency to your SQL problems, often need to force the specified target SQL to select an index or degree of parallelism to execute, today to share the SQL enforcement behavior 11

1. Force the use of an index

Select Id,name from A where id=2 with INDEX (idx_name)

2. Enforce the use of a degree of parallelism

Select Id,name from A where id=2 with option (maxdop=1)

3, Force without lock

Select Id,name from A with (NOLOCK)

4. Forced hold lock

Select Id,name from A with (Holdlock)

Above, in some special scenarios may be able to help you!

SQL Server enforces the use of specific indexes, degrees of parallelism