YYashika Vijayvargiya·Jul 1PostgreSQL Index Types Explained with Real Rails ExamplesPart-1 Understanding Indexes before learning Index TypesNow that we understand what indexes are and why they matter, let's explore the different types of indexes available in PostgreSQL and when to us6 min read·railswithyashika.hashnode.dev1
PPratyush Pragyey·Jul 5, 2025Important Database Concepts (Part-3)Learn advanced DBMS: indexes, views, transactions, and functional dependencies for improved database performance, security, and reliability15 min read·sypnops.hashnode.dev
KKhan Mohammed ahmed·Jun 26, 2025Complete Guide to Composite Indexes: From Theory to PracticeLearn how composite indexes can boost SQL query performance by 600x. Complete guide with real examples, time complexity analysis, and EXPLAIN plans for Post7 min read·guidetocompositeindex.hashnode.dev
