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 truncate the log in sql server 2012? : sql server database administration
How many columns can exist together per table?
What are the benefits of filtered indexes?
Explain the creation and execution of a user-defined function in the sql server?
Explain differences between web edition and business edition?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
how to use DTS package in 2000,2005,2008 in sql server
Is it possible in sql table to have more than one foreign key?
what purpose does the model database serve? : Sql server database administration
What is instead of dml trigger?
What is raid? : SQL Server Architecture
What does indexation mean?
What is #temp and @table variable in SQL server?
Do you know what is a trace frag? Where do we use it?
how many no of arguments can be passed in procedures and functions