Thanks for replying. Yes, I’m in the SQL Editor running queries.
I’ve seen the AutoCommit option, but wasn’t exactly sure what it was doing. Of the several query tabs that I have open right now, one had AutoCommit = off and the other query tabs were on.
I’m running queries in a Data Warehouse environment. Normally we do not use transactions because the risk of impacting other processes with a tranasaction is higher than the risk of a dirty read. Therfore…
One concern I have is that TDP is automatically creating a transaction for each query. If so, I need to turn off this feature.