> For the complete documentation index, see [llms.txt](https://koboo.gitbook.io/en2do/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://koboo.gitbook.io/en2do/usage/index/compound-index-multi-field-index.md).

# Compound Index (Multi-Field-Index)

Combining multiple fields to one identifier/index.

Since the access does not always necessarily take place on the unique identifier, there is also the possibility to combine several fields at the same time to an index. This annotation is used for this function:

* `@CompoundIndex(value = { @Index("fieldName1"), @Index(value = "fieldName2", ascending = false) }, uniqueIndex = true)`

In the example, an index is created on the `firstName` and `lastName` of the `Customer` entity, which would speed up the method `findFirstByFirstNameAndLastName(String first, String last);`.

It's possible to add multiple `@CompoundIndex` annotations in one entity.

*Example of multiple fields combined to one index:*

```java
// Lombok's annotations go here..

// Creating new multi-field index, a so called CompoundIndex
@CompoundIndex({@Index("firstName"), @Index(value = "lastName", ascending = false)}) // en2do
@CompoundIndex(value = {@Index("uniqueId"), @Index("firstName")}, uniqueIndex = true) // en2do
public class Customer {

    @Id // en2do
    UUID uniqueId;

    String firstName;
    String lastName;
    // Other fields go here...
}
```