Skip to main content

 

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Database Indexes

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • When a developer creates a foreign key in Service Studio, with the delete rule set to Protect or Delete, the platform automatically creates an index. In the database, this index has the OSIDX prefix. The platform deletes the automatically created indexes when you set Delete Rule to Ignore.

    The platform manages all indexes starting with OSIDX_. You shouldn't create or edit indexes starting with OSIDX_, as any custom changes are discarded. Additionally, you may impact the correct functioning of the apps.

    Create indexes in Service Studio

    Developers can define custom indexes in Service Studio to improve the performance of the apps. Creating new indexes in Service Studio is the preferred way of creating database indexes.

    Seen Create an Entity Index for instructions about creating indexes in Service Studio.

    Create indexes through SQL

    If you're creating indexes through SQL interface, make sure you give them a custom prefix. Here are some examples of queries.

    CREATE UNIQUE INDEX MYINDEX_<internal name> ON <Entity>(<attributes>)

    CREATE INDEX MYINDEX_<internal name> ON <Entity>(<attributes>)

    Note: If you are using an Oracle database, you can define the Indexes tablespace in the Configuration Tool.

    • Was this article helpful?