Sep 5, 2025 · 3 min read · 🚨 Problem: When your SQL queries involve filtering and sorting using multiple columns, relying on individual (single-column) indexes often causes the database to ignore those indexes — or worse, perform a full table scan. This results in slower perf...
Join discussion
Oct 24, 2024 · 4 min read · In this article I’m going to be talking about indexing and performance optimization when using SQL. SQL Indexing You can think of indexing as a table of contents in a book. It helps the database to find data faster. If there are no indexes then the d...
Join discussion
Sep 29, 2024 · 4 min read · What is an indexing? Indexing is a technique used by SQL databases to exact the data fasters. Means our DB will maintain a sub-table for our records and utilize that table to identify the expected data. Sounds confusing😕 let’s take look into the rea...
Join discussion
May 12, 2024 · 2 min read · Indexes in SQL are data structures that speed up searching and sorting in tables by storing references to specific columns. They allow databases to quickly locate relevant data when executing queries, avoiding the need to scan the entire table. The C...
Join discussion