What isolation level does TPC-D require? TPC-D has three fundamental isolation level requirements as stated in Clause 3.
• Between any two ACID transactions, serializability is required. • Between any ACID transaction and an “arbitrary” transaction, repeatable reads are required but phantoms are allowed. • Between any TPC-D query (1 through 17) and any ACID transaction, the reading of committed data is required (i.e., dirty writes and reads are disallowed), but non-repeatable reads and phantoms are allowed.
