Package jakarta.persistence

Annotation Interface Index

@Target({}) @Retention(RUNTIME) public @interface Index
Used in schema generation to specify creation of an index.

The syntax of the columnList element is given by the following simple BNF: 

    column_list ::= index_column [, index_column]*
    index_column ::= column_name [ASC | DESC]

If neither ASC nor DESC is not specified, ASC, that is, ascending order, is assumed.

Note that it is not necessary to specify an index for a primary key, as the primary key has a unique constraint with an index created automatically.

Since:
2.1
See Also:

  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    String
    columnList
    (Required) The columns included in the index, in order, following the BNF rule column_list given above.

  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
    String
    name
    (Optional) The name of the index.
    String
    options
    (Optional) A SQL fragment appended to the generated DDL which creates this index.
    boolean
    unique
    (Optional) Whether the index is unique.

  • Element Details

    • name

      String name
      (Optional) The name of the index.

      Defaults to a provider-generated name.

      Default:
      ""

    • columnList

      String columnList
      (Required) The columns included in the index, in order, following the BNF rule column_list given above.

    • unique

      boolean unique
      (Optional) Whether the index is unique.
      Default:
      false

    • options

      String options
      (Optional) A SQL fragment appended to the generated DDL which creates this index.
      Since:
      3.2
      Default:
      ""