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
