Index

Also written: indexes

A sorted list of one column's values, each pointing at its rows, so the database can jump straight to matches instead of scanning every row. It slightly slows writes, so index only the columns you search by.