When defining your entities, you can specify indexes, in addition to the ones automatically created by OutSystems Platform.
For each foreign key you create with its delete rule set to Protect or Delete, OutSystems Platform automatically creates an index. On the database, this index is prefixed with OSIDX.
CREATE INDEX OSIDX_<internal name> ON <Entity> (<reference attribute>)
Automatic indexes are deleted if the attribute Delete Rule is changed to Ignore.
You can define your own indexes, improve the performance of your applications. When you create an index, OutSystems Platform creates it on the database with the OSIDX prefix.
CREATE UNIQUE INDEX OSIDX_<internal name> ON <Entity> (<attributes>)
CREATE INDEX OSIDX_<internal name> ON <Entity> (<attributes>)
If you are using an Oracle database, you can define the Indexes tablespace, in the Configuration Tool.
Define Primary Key | Define Indexes