What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 35546 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / venkat reddy.ravu
**clustured index unique for a table,that reorders the data
which is physically stored in a table.Leaf node ie end
point of the clustured index contains the data pages.
**non clustured indexes logical order doesent meets the
physical order of the data in disk.leaf nodes of non
clustured indexes not contains data pages,instead contains
index rows.we can create 249 non clustured indexes on a
table.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Explain about analysis services?
What is the difference between varchar and nvarchar?
What are a scheduled jobs?
What does the on update no action do?
Can a synonym name of a table be used instead of a table name in a select statement?
Explain DBCC?
What is the meaning of sql server?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Explain the creation and execution of a user-defined function in the sql server?
What are exact numeric data types in ms sql server?
What is Extended user-defined?
What do you need to connect php to sql server?
Is it possible to update the views? If yes, how, if not, why?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is cross join in sql server joins?
