Composite Index

Definitions

1. A database index built on multiple columns in a defined order so queries filtering or sorting on those combined fields can be served efficiently. Composite index design matters because the column order determines which query shapes benefit and which do not.

   In plain English: A database index built from more than one column.

   Example: "The slow query disappeared after adding a composite index on tenant ID, status, and created-at because that matched the real filter pattern exactly."

Related Terms

• Persistence
• Seed Data
• Snapshot
• Subquery
• Automated Migration
• Blob
• Cascading Delete
• Cascading Update
• Code Database
• Column Index