Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38213 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 system views?
What are the different types of columns types constraints in the sql server?
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?
What is data compression?
What the different types of Replication and why are they used?
What is cached report?
How do you delete a data source?
Tell me what is difference between view and materialized view?
How many replicas are maintained for each SQL Azure database?
What are the authentication modes in sql server? How can it be changed?
What is forward - only cursors / read only cursor?
How to list all columns in a table using odbc_columns()?
What methods do you follow to protect from sql injection attack?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Find first and last day of current month in sql server
