How many index keys possible for a table

Answers were Sorted based on User's Feedback



How many index keys possible for a table..

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

How many index keys possible for a table..

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

How many index keys possible for a table..

Answer / namz

There can only be one clustered index but multiple non-
clustered index

Is This Answer Correct ?    8 Yes 2 No

How many index keys possible for a table..

Answer / koti

250 indexes(1 cluster index,249 non-cluster indexes)

Is This Answer Correct ?    7 Yes 1 No

How many index keys possible for a table..

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

How many index keys possible for a table..

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

Post New Answer

More SQL Server Interview Questions

How to provide column names in insert statements in ms sql server?

0 Answers  


What do you understand by sql server agent?

0 Answers  


How can I know what locks are running on which resource?

0 Answers  


How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,


What is a result set object returned by mssql_query()?

0 Answers  


how can a database be repaired? : Sql server administration

0 Answers  


write coding for importing sql data into a word excel...

1 Answers   Oracle,


How to find the date and time of last updated table?

3 Answers  


How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,


What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,


explain different types of joins? : Sql server database administration

0 Answers  


How to stop a loop early with break statements in ms sql server?

0 Answers  


Categories