I’m trying to optimize calls to a db2-database. I’m using spring-boot with hikari-pools. One hikari-pool is dedicated for read-only connections, and the other one handles the write-transactions.

I read, that if you set your transactions/connections to read-only, they will be optimized. But I was wondering if the same works for write-only?

Is there a setting for hikari-connection-pools and db2-databases, that lets you optimize transactions, that are write-only and do not require any reads?