Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38175 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 do you size a resultset?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is attribute? : sql server analysis services, ssas
What are the different normalization forms?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is RAID? What are the different types of RAID configurations?
What is resource db in sql server?
When is the use of update_statistics command?
What is difference between clustered and non clustered index?
Can we perform backup restore operation on tempdb? : sql server database administration
When would you use the stored procedures or functions?
Do you know what is openxml in sql server?
How do you use a subquery to find records that exist in one table and do not exist in another?
How can a user-defined datatype be created?
What are diverse clauses that form a part of sql?
