How many index can be created for single table
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Get Current System Date Time
how many triggers you can have on a table? : Sql server database administration
What is tempdb in sql server?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
Can group by be used without aggregate functions?
List out different types of normalizations in sql server and explain each of them?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
How to genrate automaticlly empid like gt001
What is an expression in ms sql server?
How to find 6th highest salary from Employee table ?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,