Composite Index

GPTKB entity

Statements (24)
Predicate Object
gptkbp:instanceOf Database Index
gptkbp:affects Query Optimization
gptkbp:alternativeTo Single-Column Index
gptkbp:canBe Unique
Foreign Key
Non-Unique
Primary Key
gptkbp:composedOf Multiple Columns
gptkbp:definedIn Column Order
gptkbp:enables Efficient Multi-Column Search
gptkbp:example INDEX idx_name (col1, col2)
https://www.w3.org/2000/01/rdf-schema#label Composite Index
gptkbp:improves WHERE col1 = ? AND col2 = ?
gptkbp:mayNotHelp WHERE col2 = ? AND col1 = ?
gptkbp:orderMatters True
gptkbp:purpose Improve Query Performance
gptkbp:supportedBy gptkb:MySQL
gptkb:Oracle_Database
gptkb:PostgreSQL
gptkb:SQL_Server
gptkbp:usedIn NoSQL Database
Relational Database
gptkbp:bfsParent gptkb:Trinidad_and_Tobago_Stock_Exchange
gptkbp:bfsLayer 6