An index allows rows of a [[Invantive Studio/Repository/Applications/Tables|table]] to be found quickly and can ensure that a combination of columns is unique, such as the index that gives each application a unique code. Its columns are listed as [[Invantive Studio/Repository/Applications/Index Columns|index columns]]. The indexes of a table are listed under the table as "Indexes". The indexes of the table of banks: ![[20261004-studio-indexes.png]] The unique index of a table named after its [[Invantive Studio/Repository/Concepts/Natural Key|natural key]] plays a special part: the business layer uses it to recognise a row by its codes. ## Fields The details of an index show these fields: - "Table Code": Unique alphanumeric code. - "Application Code": Unique alphanumeric code of the application. - "Name": Name of the index. - "Unique": Whether the combination of the columns of the index must be unique. - "Create": Whether the index will be created. ## Tabs The summary window of an index shows its related rows on these tabs: - [[Invantive Studio/Repository/Applications/Tables|Table]] - [[Invantive Studio/Repository/Applications/Index Columns|Index Columns]]