what is index & what are the main purpose of index
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.
OSIDX
link : https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Database_Reference/Database_Indexes
how to create an index : https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Create_an_Entity_Index
i hope this will help you.........
Hi,
An index can be define on one or a combination of entity attributes. It has several purposes.
First and most important it can improve performance of searching entity records as the database does not need to scan all records to check if they match your filter criteria.
Second it can enforce uniqueness of data as you can configure the index not to accept more than 1 record with the combination of attribute values that are part of the index.
regards,
Daniel
As it speeds up searching the entity when you search with the indexed fields, it also slows down update sql, because it has to update the indexes as well.
Since search and select entities more than we update, its benefits outweighs the disadvantages most of the time.
Simply index is like your book's indexes where their main purpose is to speed up your searching on any item.
regards
Hi @Vijitha N
An index is a database structure that you can use to improve the performance of database activity. A database table can have one or more indexes associated with it. An index is defined by a field expression that you specify when you create the index. Typically, the field expression is a single field name.
Go through
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Create_an_Entity_Index
Hope that helps.
thanks and regards
vednarayan