> DB2: > Uncommitted Read (UR) mode "Dirty read" isn't the default, or > the recommended lock level for most apps. I was considering > Cursor Stability mode (or higher), which is the default
Sorry, they call it "read committed" but actually do cursor stability, which does keep one lock on the last fetched row. Keeping the lock would actually not be necessary to conform with ANSI "read committed". See table 4 on Page 8 of http://www.cs.ndsu.nodak.edu/~yawang/Snapshot.ppt > SQLServer: > READ COMMITTED does take share locks. But it does not hold them. According to docu it holds them "while reading" which is not a very detailed description. How long is that really, e.g. with odbc forward cursor fetch ? > There's a NO LOCK hint, true, but its not a default. That is for dirty/uncommitted reads. Andreas ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
