Re: read only transactions

Jon Nelson  wrote:
 
> Are there any performance implications (benefits) to executing
> queries in a transaction where
> SET TRANSACTION READ ONLY;
> has been executed?
 
I don't think it allows much optimization in any current release.
 
It wouldn't be a bad idea to use it where appropriate, though, as
future releases might do something with it.  If you include this on
the BEGIN statement, that will save a round trip.
 
-Kevin