Index

• Unique Indexes
• Full-Text Indexes
• Spatial Indexes
• Multi-Valued Indexes
• Function Index

Unique Indexes

index.yaml

# primary key
- table: User
  type: primary
  columns:
    - name: ID

# unique index
- table: User
  type: unique
  columns:
    - name: Email

Full-Text Indexes

index.yaml

# Index `Name` column with descending order
- table: User
  type: fulltext
  columns:
    - name: Name
      direction: desc
  comment: "User's full name"

Spatial Indexes

index.yaml

- table: User
  type: spatial
  columns:
    - name: Location

Multi-Valued Indexes

index.yaml

- table: User
  type: multi-valued
  columns:
    - name: Location