Index (EN)

Concept

Data structure that improves query speed on specific columns

Architecture

flowchart LR   A[Query] --> B[Index]   B --> C[Database]   D[New record] --> E[Update index]   E --> C

In Context

  • Typically used together with primary keys, foreign keys, and query optimization
  • Related to: Database, query optimization, B-tree, hash index
  • Example use: Fast search in large tables through WHERE clauses on indexed columns
Quelle: AI Generated