Indexing Strategy

Coming up with an indexing strategy is an important step in terms of mastering our PostgreSQL database. It means that we’re in a position to make an informed choice about which indexes we need and don’t need in our application. A PostgreSQL index allows the system to have new options to find the data our queries need. In the absence of an index, the only option available to our database is a sequential scan of our tables. The index access methods are meant to be faster than a sequential scan by fetching the data directly where it is.