1

I have found that Teradata uses:

READ_ISOLATION_LEVEL= ACCESS|READ|WRITE

How it correspond to usual read commited/dirty in usual databases? Thanks.

Bhargav Rao
  • 50,140
  • 28
  • 121
  • 140
user710818
  • 23,228
  • 58
  • 149
  • 207

1 Answers1

1

Not sure if this addresses your question entirely:

ACCESS locking would allow dirty reads allows WRITE lock to be in place. READ locking allows only committed reads and can block WRITE/EXCLUSIVE locks while reading data. WRITE lock prevents READ locks from access data but allows ACCESS (dirty read) lock to access data.

Rob Paller
  • 7,736
  • 29
  • 26