SSSumanau Sareeninsumanau.hashnode.dev·Nov 25, 2021 · 9 min readDatabase indexing -101 (Part 2)Let's take an example of a query to better understand how indexes work and how they can help. We take a simple Payment table which saves a timestamp of whenever a user makes a payment in our system. create table payment ( payment_time TIMESTAMP NO...01A
SSSumanau Sareeninsumanau.hashnode.dev·Nov 24, 2021 · 4 min readDatabase Indexing - 101What is a Database Index? Quoting wikipedia : "A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. In...00
