Courses
Tutorials
Practice

Similar Topics

Web Technologies37.4K+ articles

DSA22.8K+ articles

Misc8.8K+ articles

Databases2.2K+ articles

DBMS1.6K+ articles

SQL1.5K+ articles

Advanced Data Structure595+ articles

dbms45+ articles

SQL-basics26+ articles

B-Tree17+ articles

DBMS Indexing

11 posts

Difference Between Indexing Techniques in DBMS

Last Updated: 17 September 2024

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: 01 May 2023

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: 14 February 2023

Pre-requisites: Primary Indexing in Databases, indexingDatabases are a crucial component of modern computing, providing a structured way to store, manage, and retrieve vas...read more

Secondary Indexing in Databases

Last Updated: 14 February 2023

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: 22 May 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: 28 November 2024

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: 17 April 2025

When it comes to relational database performance optimizing, SQL indexes are a game changer. Imagine them like an index in a book instead of flipping through every page (r...read more

Indexing in Databases - Set 1

Last Updated: 06 May 2025

Indexing is a crucial technique used in databases to optimize data retrieval operations. It improves query performance by minimizing disk I/O operations, thus reducing the...read more

article_image

Delete Operation in B-Tree

Last Updated: 24 February 2025

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

Advanced Data Structure

Insert Operation in B-Tree

Last Updated: 14 January 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

Advanced Data Structure

Introduction of B-Tree

Last Updated: 29 January 2025

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

Advanced Data Structure

Self-Balancing-BST