Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 37843 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
How to maintain a fill factor in existing indexes?
How do I start sql server 2016?
List the various tools available for performance tuning?
Do you know the policy based administration feature of sql server 2008?
How can you stop stored procedures from recompiling?
What is unique key constraint?
Do you know hot add cpu in sql server 2008?
What are extended events in sql server?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Detail about query optimizer?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the use of builtinadministrators group in sql server? : sql server security
What is user-defined multi-statement table-valued function?
What command would you use to add a column to a table in sql server?
What is the sql case statement used for?
