In the previous article, we discussed what is Indexing and why it is an important part of our Database. Now let’s see a practical example how efficiently created indexing can help us and how can we figure out the same.

Querying Postgres databases, when done properly, can result in extremely efficient results and provide powerful insights. Sometimes, however, queries are written in less than optimal ways, causing slow response times. Because of this, it is important to be able to analyze how queries execute and find the most optimized ways to run them.

One method for optimizing queries is to…

Jay Prakash

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store