Is it possible to specify in a select to use snapshot mode instead of serialize mode?
In sql server you could do something like this
select * from Table with(nolock) which is a hint to use read uncomitted.
I use this often because I don’t want to block writes, and my usecase isn’t life or death or financial, so missing a newly inserted row is no big deal. I know with transactions you can set the isolation level to snapshot, but I tend to avoid transactions as again, my use-case is not life or death or financial, so the priority is speed over all else.
Just curios if this is possible already and I missed it in the docs or something that is on the roadmap? Thanks!