If you have a million or a ton of data with transactions of retrieval in seconds, you can’t even escape opting for Indexing. Performance is key for most products, especially e-commerce services. The solution is to reduce the response time and the database is optimized to perform this search. We are only worried about the column to index and the primary key is always the index.

In this article, we will learn more about this by focusing on the good and downsides of Indexing