IndexDefinition: BtreeIndex | InvertedIndex

You can optimize query performance by defining an index to apply to a container. You can only create an index across properties belonging to the same container.

Ordering of the properties included in the index definition list is significant. The order should match the queries you expect. The properties of an index cannot be updated after creation. If you need to change the index, it must be recreated.

Indexes have different requirements for the different property data types. As a result, the create index operation will fail if you specify an invalid combination.

Up to 10 indexes can be added on a container.'