---
title: "Indexing in DBMS"  
description: "Indexing in DBMS"  
author: "Anonymous User"  
published: 2018-06-22  
updated: 2018-06-23  
canonical: https://www.mindstick.com/forum/34537/indexing-in-dbms  
category: "database"  
tags: ["database", "db2", "index", "database design"]  
reading_time: 1 minute  

---

# Indexing in DBMS

What is [indexing](https://www.mindstick.com/blog/303693/how-search-engines-work-crawling-indexing-and-ranking) in [DBMS](https://www.mindstick.com/forum/145506/what-is-deadlock-condition-in-dbms)? Types of indexing?

\

## Replies

### Reply by Prakash nidhi Verma

Indexing is a data structure technique used to find data more quickly and efficiently in a table. An index is a small table having only two columns. The first column having candidate key of a table and second column contains a set of pointers which is holding the address of the disk block where that particular key value can be found. data is stored like a records.Every record has a key field. Indexing is a data structure technique to efficiently access records from the database files which is work on attributes on the indexing has been done.

Indexes are of 3 types :

- Primary indexes

- Secondary indexes

- Clustering indexes


---

Original Source: https://www.mindstick.com/forum/34537/indexing-in-dbms

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.