How many index can be created for single table

Answers were Sorted based on User's Feedback



How many index can be created for single table..

Answer / somu

We can create total 250 indexes per table . i,e 1 Clustered
Index and 249 Non Clustered Indexes

Is This Answer Correct ?    25 Yes 1 No

How many index can be created for single table..

Answer / sanjay kumar dinda

Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index

We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...

Is This Answer Correct ?    17 Yes 0 No

How many index can be created for single table..

Answer / infant vinoth

surely we can create an index,
one cluster index,249 will be the non cluster..all the best

Is This Answer Correct ?    9 Yes 0 No

How many index can be created for single table..

Answer / sureshsamatham

There can be 1 or more indexes in a table.Indexes can be
clustered or non clustered. A clustered index stores data
rows in the table based on their key values. Each table can
have only one clustered index as the key values in the data
rows are unique and the index is built on the unique key
column. Non-Clustered indexes have structures that are
different from the data rows. A non clustered index key
value is used to point to data rows that contain the key
value. This value is known as row locator. The structure of
the row locator is determined on the basis of the type of
storage of the data pages. If the data page is stored as a
heap, a row locator becomes a pointer to a row. If the data
page is stored in a clustered table the row locator is a
clustered index key. Clustered and Non clustered indexes can
be unique and indexes are automatically maintained for a
table or view whenever the data table is modified.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How to stop log file growing too big?

0 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  


What is difference between temp table and cte?

0 Answers  


What are the four main query statements?

7 Answers   Wipro,


A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,


what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


What are the different types of triggers in SQL SERVER?

0 Answers  


How do you simulate a deadlock for testing purposes

1 Answers  


difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


Do you know what are acid properties of transaction?

0 Answers  


what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  


Categories