I have found that Teradata uses:
READ_ISOLATION_LEVEL= ACCESS|READ|WRITE
How it correspond to usual read commited/dirty in usual databases? Thanks.
I have found that Teradata uses:
READ_ISOLATION_LEVEL= ACCESS|READ|WRITE
How it correspond to usual read commited/dirty in usual databases? Thanks.
Not sure if this addresses your question entirely:
ACCESSlocking would allow dirty reads allowsWRITElock to be in place.READlocking allows only committed reads and can blockWRITE/EXCLUSIVElocks while reading data.WRITElock preventsREADlocks from access data but allowsACCESS(dirty read) lock to access data.