---
title: "How  many cluster index and  non cluster index we can create in a table?"  
description: "How  many cluster index and  non cluster index we can create in a table?"  
author: "Anonymous User"  
published: 2012-09-15  
updated: 2012-09-18  
canonical: https://www.mindstick.com/forum/451/how-many-cluster-index-and-non-cluster-index-we-can-create-in-a-table  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# How  many cluster index and  non cluster index we can create in a table?

Hello Everyone,\
Can [anyone tell me](https://www.mindstick.com/interview/23033/can-anyone-tell-me-about-hadoop-toolbox) how many [cluster index](https://www.mindstick.com/interview/23556/what-is-cluster-index-in-sql) and non cluster index we can create in a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap)?\
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!!

## Replies

### Reply by John Smith

A table can have 249 [index](https://www.mindstick.com/blog/198/index-in-sql-server)\
1 [Cluster](https://www.mindstick.com/interview/22873/what-is-class-cluster)\
248 Non cluster


---

Original Source: https://www.mindstick.com/forum/451/how-many-cluster-index-and-non-cluster-index-we-can-create-in-a-table

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