What is the basic difference between clustered and a
non-clustered index?
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
How to update multiple rows with one update statement in ms sql server?
What are sql server functions?
What is the difference between a "where" clause and a "having" clause?
Mention the command used to rename the database.
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is a non-clustered index?
what is the difference between openrowset and openquery?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is filestream?
What are the advantages of user defined function?
What is the importance of concurrency control?
What is purpose of normalization?
Does hive support indexing?
How except clause is differs from not in clause?
How to download and install microsoft sql server management studio express?