We are having a oracle DB, but seems like indexes are not working. Is Oracle don’t use the indexes which were created as Outsystem does not pass the input parameters to Oracle? How can we add indexes from Outsystem side?
Hello,
I suppose this is what you need. Follow the steps and I think that's it.
Regards,
Jorge Rodrigues
Hello Aleena, how are you?
If you are creating your Entities / Tables in Service Studio, Jorge's answer is correct, otherwise, see this article:
https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Database_Reference/Database_Indexes
Note: If you are using an Oracle database, you can define the Indexes tablespace in the Configuration Tool.
https://success.outsystems.com/Documentation/11/Reference/Configuration_Tool/Platform_Tab/Platform_Tab_in_Oracle
Hope its Help.
Kind regards.