ArangoDB v3.9 reached End of Life (EOL) and is no longer supported.
This documentation is outdated. Please see the most recent version at docs.arangodb.com
Indexes
Indexes can be ensured using the following annotations. For reference see the indexing documentation and specific aspects that apply to indexes on shards.
Annotation @<IndexType>Indexed
With the @<IndexType>Indexed
annotations user defined indexes can be created at a collection level by annotating single fields of a class.
Possible @<IndexType>Indexed
annotations are:
@PersistentIndexed
@GeoIndexed
@FulltextIndexed
@TtlIndexed
The following example creates a persistent index on the field name
and a separate persistent index on the field age
:
public class Person {
@PersistentIndexed
private String name;
@PersistentIndexed
private int age;
}
With the @<IndexType>Indexed
annotations different indexes can be created on the same field.
The following example creates a TTL index and also a persistent index on the field name
:
public class Person {
@TtlIndexed
@PersistentIndexed
private String name;
}
Annotation @<IndexType>Index
If the index should include multiple fields the @<IndexType>Index
annotations can be used on the type instead.
Possible @<IndexType>Index
annotations are:
@PersistentIndex
@GeoIndex
@FulltextIndex
@TtlIndex
The following example creates a single persistent index on the fields name
and age
, note that if a field is renamed in the database with @Field, the new field name must be used in the index declaration:
@PersistentIndex(fields = {"fullname", "age"})
public class Person {
@Field("fullname")
private String name;
private int age;
}
The @<IndexType>Index
annotations can also be used to create an index on a nested field.
The following example creates a single persistent index on the fields name
and address.country
:
@PersistentIndex(fields = {"name", "address.country"})
public class Person {
private String name;
private Address address;
}
The @<IndexType>Index
annotations and the @<IndexType>Indexed
annotations can be used at the same time in one class.
The following example creates a persistent index on the fields name
and age
and a separate persistent index on the field age
:
@PersistentIndex(fields = {"name", "age"})
public class Person {
private String name;
@PersistentIndexed
private int age;
}
The @<IndexType>Index
annotations can be used multiple times to create more than one index in this way.
The following example creates a persistent index on the fields name
and age
and a separate persistent index on the fields name
and gender
:
@PersistentIndex(fields = {"name", "age"})
@PersistentIndex(fields = {"name", "gender"})
public class Person {
private String name;
private int age;
private Gender gender;
}