3 docs tagged with "functional indexes"

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

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.

Learn how to create functional (expression) indexes in SQLite to speed up case-insensitive searches and queries on computed values, and how to manage them in schema migrations with Atlas.