6 docs tagged with "mysql hcl schema"

Learn how to use CHECK constraints in MySQL to enforce data integrity. This guide covers syntax, examples, and how to manage CHECK constraints with Atlas.

Learn how to create and use descending indexes in MySQL to optimize queries with ORDER BY clause, and how to manage them using Atlas.

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

Learn how to use generated columns in MySQL with Atlas. Understand the difference between stored and virtual generated columns, their limitations, and how to implement them using Atlas HCL schema.

function

Learn how to create and use prefix indexes in MySQL to optimize query performance and reduce storage space. Understand the syntax, examples, and benefits of using prefix indexes.