Column Index

Definitions

1. A database index built on one or more columns to speed lookups, filtering, joins, or sorting on those fields. Column indexes improve read performance dramatically for targeted queries, but they also add storage cost and slow writes because the index must be maintained.

   In plain English: A database index built on specific columns to make queries faster.

   Example: "The report query improved from seconds to milliseconds after adding a column index on tenant ID and created-at."

Related Terms

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