we can create ony ONE clustered index per table .. for Non- clusrtered ind

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / raju.r

Answer Posted / raju.r

we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...

Is This Answer Correct ?

4 Yes

11 No

Please Help Members By Posting Answers For Below Questions

How does clustered and non clustered index work?

928

What is snapshot parameter in ssrs?

150

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

966

What do you mean by table and field in sql?

1015

What happens to a statement batch if there is a compilation error?

969

What is a transact-sql statement?

1067

What are different types of subquery?

1247

What are the purposes of floor and sign functions?

978

What is data source document?

1044

What is the library index called?

1060

What are trace flags and mention a few common trace flags used with sql server?

1089

What do you understand by recursive stored procedure?

933

What is resource db in sql server?

1030

How do I setup a sql server database?

1078

What is the sql server 2000 version number?

1083