Composite index (database)

A database composite index or multi-column index is an index that is based on multiple columns.[1]

## References

[edit]

1. ^ "MySQL 5.0 Reference Manual".

* v
* t
* e

Database management systems

Types|

* Object-oriented
* comparison
* Relational
* list
* comparison
* Key–value
* Column-oriented
* list
* Document-oriented
* Wide-column store
* Graph
* NoSQL
* NewSQL
* In-memory
* list
* Multi-model
* comparison
* Cloud
* Blockchain-based database

Concepts|

* Database
* ACID
* Armstrong's axioms
* Codd's 12 rules
* CAP theorem
* CRUD
* Null
* Candidate key
* Foreign key
* PACELC design principle
* Superkey
* Surrogate key
* Unique key

Objects|

* Relation
* table
* column
* row
* View
* Transaction
* Transaction log
* Trigger
* Index
* Stored procedure
* Cursor
* Partition

Components|

* Concurrency control
* Data dictionary
* JDBC
* XQJ
* ODBC
* Query language
* Query optimizer
* Query rewriting system
* Query plan

Functions|

* Administration
* Query optimization
* Replication
* Sharding

Related topics|

* Database models
* Database normalization
* Database storage
* Distributed database
* Federated database system
* Referential integrity
* Relational algebra
* Relational calculus
* Relational model
* Object–relational database
* Transaction processing

* Category
* Outline

This database software-related article is a stub. You can help Wikipedia by expanding it.

|

* v
* t
* e

*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template