Let’s look into some of the features of sql data indexing. This will be super helpful while developing our Rails 8 Application. 💎 Part 1: What is a Covering Index? Normally when you query: Database searches username index (secondary). Finds a pointer (TID or PK). Then fetches full row from table (heap or clustered B-tree). … Continue reading Rails 8 App: Setup Test DB in PostgreSQL | Covering Index | BRIN Indexes | Hash Indexes | Create super fast indexes