Skip to main content

3 docs tagged with "functional indexes"

View all tags

Functional Indexes in MySQL

Learn how to create and manage functional indexes in MySQL to optimize query performance using expressions and functions.

Functional Indexes in PostgreSQL

Learn how to use functional indexes in PostgreSQL to optimize query performance by indexing expression values. This guide covers syntax, examples, and how to manage them in schema migrations with Atlas.