Statements (24)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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)
|
| 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
|
| https://www.w3.org/2000/01/rdf-schema#label |
Composite Index
|