--- title: "#database-indexes articles | Hashnode" description: "Explore 4 articles tagged #database-indexes on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/database-indexes" --- Tag # #database-indexes 4 posts · 0 followers [Yashika Vijayvargiya](https://hashnode.com/@railswithyashika) · [Jul 1](https://hashnode.com/posts/postgresql-index-types-explained-with-real-rails-examples/6a44cc6dc7a6e89782b816fd) ### [PostgreSQL Index Types Explained with Real Rails Examples](https://railswithyashika.hashnode.dev/postgresql-index-types-explained-with-real-rails-examples?utm_source=hashnode&utm_medium=feed) Part-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 us 6 min read · [railswithyashika.hashnode.dev](https://railswithyashika.hashnode.dev/postgresql-index-types-explained-with-real-rails-examples?utm_source=hashnode&utm_medium=feed) [Pratyush Pragyey](https://hashnode.com/@Eyepatch5263) · [Jul 5, 2025](https://hashnode.com/posts/important-database-concepts-part-3/6868d19917c1aea652a7da09) ### [Important Database Concepts (Part-3)](https://sypnops.hashnode.dev/important-database-concepts-part-3?utm_source=hashnode&utm_medium=feed) Learn advanced DBMS: indexes, views, transactions, and functional dependencies for improved database performance, security, and reliability 15 min read · [sypnops.hashnode.dev](https://sypnops.hashnode.dev/important-database-concepts-part-3?utm_source=hashnode&utm_medium=feed) [Khan Mohammed ahmed](https://hashnode.com/@khanAhmed) · [Jun 26, 2025](https://hashnode.com/posts/complete-guide-to-composite-indexes-from-theory-to-practice/685d49d36161f4a925fcc152) ### [Complete Guide to Composite Indexes: From Theory to Practice](https://guidetocompositeindex.hashnode.dev/complete-guide-to-composite-indexes-from-theory-to-practice?utm_source=hashnode&utm_medium=feed) Learn how composite indexes can boost SQL query performance by 600x. Complete guide with real examples, time complexity analysis, and EXPLAIN plans for Post 7 min read · [guidetocompositeindex.hashnode.dev](https://guidetocompositeindex.hashnode.dev/complete-guide-to-composite-indexes-from-theory-to-practice?utm_source=hashnode&utm_medium=feed)