Tutorials
Courses

Similar Topics

Web Technologies33.1K+ articles

DSA20.1K+ articles

Difference Between3.2K+ articles

SQL1.4K+ articles

DBMS1.3K+ articles

Advanced Data Structure538+ articles

DBMS-SQL527+ articles

dbms46+ articles

SQL-basics26+ articles

B-Tree17+ articles

DBMS Indexing

11 posts

Last Updated: 21 June 2025

An index in SQL is a schema object that improves the speed of data retrieval operations on a table. Imagine them like an index in a book instead of flipping through every ...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

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

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

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

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

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

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

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

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