Similar Topics

Web Technologies32.1K+ articles

DSA20.4K+ articles

Databases1.9K+ articles

SQL1.4K+ articles

DBMS1.3K+ articles

DBMS-SQL531+ articles

dbms51+ articles

SQLmysql50+ articles

SQL-basics38+ articles

B-Tree17+ articles

DBMS Indexing

12 posts

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

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

Difference Between

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

article_image

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

article_image

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

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

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

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

article_image

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

article_image

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

article_image

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

article_image

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

article_image

Self-Balancing-BST