Descending Indexes in SQLite
What are descending indexes?
What are descending indexes?
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.
Overview of Partial Indexes
Comprehensive reference for defining SQLite schemas using Atlas HCL. Learn about supported blocks, attributes, and examples for schemas, tables, columns, triggers, indexes, and views in SQLite with Atlas.