Primary Keys and Indexing


  • When a database is designed properly, fields that are commonly sorted, queried, or filtered will likely be indexed

Indexing is a field property setting that tells the database that a field needs to be used to create an index.

  • is an internal process that controls how much data must be looked at when processing the data for queries
  • makes data processing faster and speeds up the performance of the query
  • act of increasing the performance of a query is called query optimization
  • when a primary key is created, then by default it is also indexed
  • any field can be set to be an index
  • indexing process initiates during the implementation and testing phases of design
    • ongoing process over the life of the database