What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 36458 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
What are the purposes and advantages stored procedure?
What is a unique key constraint?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to add code to the existing article (using improve article)?
What are temporal tables in sql server 2016?
Is it important for a database administrator to understand the operating system and file access?
Name 3 ways to get an accurate count of the number of records in a table?
How can we use ConnectorJ JDBC Driver with MS SQL?
What are number line correlation administrators will use while working with a subquery?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is merge replication?
Explain features of analysis services?
What is the command used to recompile the stored procedure at run time?
How can we delete a table in sql server?
Which are the third-party tools used in sql server and why would you use them?
