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
|