The purpose of creating databases indexes is to $q,$

$q,$

maintain the integrity of the data stored in tables

reduce the database's storage $($memory$)$ requirements

avoid searching through every row in a table with every query

grant and$/$or revoke privileges for certain actions to users