How many index keys possible for a table
Answers were Sorted based on User's Feedback
Answer / anand k
One table can only one clustered index or primary key and
249 non-clustered index or unique key
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / raji
Indexes may be defined as unique or non-unique. A unique
index acts as a constraint on the table by preventing
identical rows in the index and thus, the original columns.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / namz
There can only be one clustered index but multiple non-
clustered index
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / koti
250 indexes(1 cluster index,249 non-cluster indexes)
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / c.jagadish
In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.
Indexes may be simple index or composite index.
Index formed based on single column values is called simple
index
index formed based on multiple column values is called
composite index.
Default index is NON CLUSTERED INDEX
When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.
Unique--- automatically creates a non clustered index
so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / saravanan
four index keys is possible per one table.
read only table u havae create more then index per table
Is This Answer Correct ? | 3 Yes | 3 No |
what is index seek and index scan?
What is the use of commit?
What is data source in connection string?
What is an extended Stored Procedure?
Why use update_statistics command in sql server?
What are triggers in ms sql server?
Why are views required in the sql server or in any other database?
Do you know what is blocking?
What is database isolation in sql server? : sql server database administration
How to enter date and time literals in ms sql server?
How to find the second highest salary of an employee?
How to determine the service pack currently installed on SQL Server?