---
title: "what is cluster index in sql"  
description: "what is cluster index in sql"  
author: "Anonymous User"  
published: 2019-08-05  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/23556/what-is-cluster-index-in-sql  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# what is cluster index in sql

The clustered index defines the order in which data is physically stored in a table. The table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column

## Answers

### Answer by Anonymous User

The clustered index defines the order in which data is physically stored in a table. The table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column


---

Original Source: https://www.mindstick.com/interview/23556/what-is-cluster-index-in-sql

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