"Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > RohitPatel9999 <rohitpatel9999-/[EMAIL PROTECTED]> > wrote: > > Scenario 1 > > If action of some user needs to execute multiple SELECT statements > > (read-only, no plan to write), it needs to start explicit transaction > > to get consistent reads across read-only multiple statements. > > > > Q1. Which one is preferable -> BEGIN TRANSACTION or BEGIN IMMEDIATE > > ? > > BEGIN IMMEDIATE would block other readers. Don't use it unless you plan > to write.
BEGIN IMMEDIATE blocks writers, not readers. I believe it's what he wants. Regards