clustered index is only one clustered index per table. non clustered index

What is the basic difference between clustered and a
non-clustered index?

Question Posted / bhai(prakash.g)

Answer Posted / bhai(prakash.g)

clustered index is only one clustered index per table.
non clustered index is more than one in table.

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the web service used for reporting services?

123

What is the purpose of data source?

1032

Determine when to use stored procedure to complete sql server tasks?

1052

What is data file in computer?

939

Describe how to use linked server?

1014

What is the primary use of the model database?

1081

What are the disadvantages of merge replication?

1414

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

966

What is the function of inner join?

1068

Can the query output be sorted by multiple columns in ms sql server?

980

What happens if the update subquery returns no rows in ms sql server?

1122

Which table keeps information about stored procedures?

935

Explain cursor as data base object?

1038

What is the order by used for?

1018

What is mean by candidate key?

1006