Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 37846 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / rajesh
I am explaining you with an example, The Telephone
Directory is a fine example of Clustered Index as data and
index are at the same page, whereas index in the back side
of the book is a fine example of non-clustered index and
non-clustered index is a fast B-tree structure as index
just points to the data page. Also only one clustered index
is possible per table and 249 non-clustered index per table.
| Is This Answer Correct ? | 75 Yes | 10 No |
Post New Answer View All Answers
What is sql injection? How to protect against sql injection attack?
What is the purpose of self join?
What are the authentication modes in sql server? How can it be changed?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is inline table-value user-defined function?
How do I clean up sql server transaction log?
How would you add a section to a table?
what type of index will get created after executing the above statement? : Sql server database administration
what are the different ways to return the rowcount of a table?
What are the types of database schema? : sql server analysis services, ssas
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to create new tables with "create table" statements in ms sql server?
Difference between drill down and drill through report.
How dts is used to extract, transform and consolidate data?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
