clustered index is physically stored a table can have 1 clustered index

Difference between Cluster and Non-cluster index?

Question Posted / p.karthick

32 Answers
145966 Views
Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
E-Mail Answers

Answer Posted / p.karthick

clustered index is physically stored
a table can have 1 clustered index

non clustered index is logically stored
a table can have 249 non clustred index

Is This Answer Correct ?

193 Yes

46 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we remove orphan records from a table?

930

What are logical database components? : SQL Server Architecture

959

Can we use custom code in ssrs?

1056

What should be the fill factor for indexes created on tables? : sql server database administration

1099

What is compound operators?

974

Is null in sql server?

939

How to execute a sql statement using mssql_query()?

977

Write an sql query for deleting duplicate rows?

952

Explain the different types of backups available in sql server? : sql server database administration

862

Does partitioning help performance?

887

What are subqueries in sql server? Explain its properties.

965

How can you insert null values in a column while inserting the data?

1211

What is the default server name for sql server?

1088

Why use “in” clause in sql server?

995

How to add more data to the testing table in ms sql server?

1000