Courses
Tutorials
Interview Prep
DSA
Practice Problems
C
C++
Java
Python
JavaScript
Data Science
Machine Learning
Courses
Linux
DevOps
Similar Topics
Web Technologies
32.1K+ articles
DSA
20.4K+ articles
Databases
1.9K+ articles
SQL
1.4K+ articles
DBMS
1.3K+ articles
DBMS-SQL
531+ articles
dbms
51+ articles
SQLmysql
50+ articles
SQL-basics
38+ articles
B-Tree
17+ articles
DBMS Indexing
12 posts
Recent Articles
Storage, Indexing & Advanced Topics Interview Questions - DBMS
Last Updated: 05 January 2026
Storage in DBMS is about how data is physically stored and managed on disk. Indexing is a technique to make data retrieval faster, like a book’s index. Advanced topics inc...
read more
DBMS
dbms
DBMS Indexing
Difference Between Indexing Techniques in DBMS
Last Updated: 23 July 2025
Database indexing plays a crucial role in improving the performance and efficiency of database systems. By utilizing indexing techniques, we can speed up data retrieval op...
read more
DBMS
Difference Between
DBMS Indexing
SQL Fill Factor and Performance
Last Updated: 23 July 2025
In SQL when a index is created or rebuilt, the fill factor value determines the percentage of space on each leaf-level page to be filled with data. By setting the fill fac...
read more
SQL
DBMS Indexing
Clustering Indexing in Databases
Last Updated: 07 January 2026
Databases are a crucial component of modern computing, providing a structured way to store, manage, and retrieve vast amounts of data. As the size of databases increases, ...
read more
DBMS
DBMS Indexing
Secondary Indexing in Databases
Last Updated: 23 July 2025
Pre-requisites: Primary Indexing in DatabasesDatabases are a critical component of modern applications, storing vast amounts of data and serving as a source of information...
read more
DBMS
DBMS Indexing
Multiple Indexes vs Multi-Column Indexes
Last Updated: 23 July 2025
A database index is a data structure, typically organized as a B-tree, that is used to quickly locate and access data in a database table. Indexes are used to speed up the...
read more
DBMS
GATE CS
Picked
DBMS Indexing
SQL Queries on Clustered and Non-Clustered Indexes
Last Updated: 24 April 2026
Indexes in SQL play a pivotal role in enhancing database performance by enabling efficient data retrieval without scanning the entire table. The two primary types of index...
read more
SQL
Picked
DBMS Indexing
SQL Indexes
Last Updated: 13 April 2026
Indexes in SQL are special database structures that speed up data retrieval by allowing quick access to records instead of scanning the entire table. They act like a looku...
read more
SQL
DBMS-SQL
DBMS Indexing
mysql
SQLmysql
SQL-basics
SQL-Query
Indexing in Databases
Last Updated: 18 April 2026
Indexing in databases is a data structure technique used to speed up data retrieval operations by minimizing the number of disk accesses required to locate records. Stores...
read more
DBMS
dbms
DBMS Indexing
Databases
Delete Operation in B-Tree
Last Updated: 30 January 2026
A B Tree is a type of data structure commonly known as a Balanced Tree that stores multiple data items very easily. B Trees are one of the most useful data structures that...
read more
DSA
dbms
DBMS Indexing
B-Tree
Insert Operation in B-Tree
Last Updated: 23 July 2025
In this post, we'll discuss the insert() operation in a B-Tree. A new key is always inserted into a leaf node. To insert a key k, we start from the root and traverse down ...
read more
DSA
DBMS Indexing
B-Tree
Introduction of B Tree
Last Updated: 05 January 2026
A B-Tree is a specialized m-way tree designed to optimize data access, especially on disk-based storage systems. In a B-Tree of order m, each node can have up to m childre...
read more
DSA
Self-Balancing-BST
DBMS Indexing