DynamicQueryEngine Fields |
The DynamicQueryEngine type exposes the following members.
Name | Description | |
---|---|---|
ArithAbortOn |
Flag to signal the DQE to generate SET ARITHABORT ON statements prior to INSERT, DELETE and UPDATE Queries.
Keep this flag to false in normal usage, but set it to true if you need to write into a table which is part of an indexed view.
It will not affect normal inserts/updates that much, leaving it on is not harmful. Please consult SqlServer's Books online for
more details on SET ARITHABORT ON. After each statement the setting is turned off if it has been turned on prior to that statement.
| |
UseNoLockHintOnSelects |
Flag to signal the DQE to tell the SqlServerSpecificCreator to create WITH NOLOCK hints on table references in select queries for FROM clauses.
WITH NOLOCK is not recommended though in high volume databases with a lot of rows, it can be a lot of blocking can occur because SqlServer forces
readers to block writers and vice versa. Please consult the SqlServer's Book online for more information about this hint and also the downsides
for using it. The setting is global and for all select queries. Default is false and it should only be set to true in those situations in which
no other option is available.
|