Hi Jayson,

I don't think you can.

But you can use some of the concepts of OLTP:

• You can create indexes in OutSystems which will reflect in the database
• You can in Advanced SQL, create a temporary table (although this is more of an advanced scenario)

Regarding situations where you need OLTP:

• High scalability and gains - as I mentioned above you can use indexes and best practices to have your queries efficient. In the case you run OutSystems in a on-premises infrastructure, you can set up OutSystems DB best practices, whereas if you're running on an OutSystems cloud infrastructure these will be already in place;
• Integrating with NoSQL databases - this is possible with OutSystems, as you can see in this article which reports a successful use case using MongoDB.

I hope it helps.

Best regards,

João