ReadUncommitted

Table of Contents

Overview
Example
See also
Related

When true, the session's reads take stability locks instead of read locks. Queries then do not wait for other transactions that are writing, but they may read changes that have not been committed yet (dirty reads).

Example

SET ReadUncommitted true

See also

Home

The home page

SQL :: Declare

Declares a variable for the rest of a script.

SQL :: Keywords

A breakdown of all of the statements and keywords supported by the query processor.

SQL :: QueryThreadWeight

Removed: QueryThreadWeight is no longer a session variable.

SQL :: Session Variables

Settings that are scoped to the connected session.

SQL :: Set

Set changes a session variable.

SQL :: TraceWaitTimes

Reports the time spent in each internal operation of a query.

SQL :: Transaction

Transactions make a group of statements all-or-nothing.

SQL :: WarnMissingFields

Warns when a query references a field that a document does not have.

SQL :: WarnNullPropagation

Warns when a null makes an expression null.