What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 36441 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
How to connect Azure federated root database and apply federation in entity framework?
How to specify the collation for a character data type in ms sql server?
Explain what is the main purpose of having conversation group?
How many ways to create table-valued functions?
What is a self join in sql server?
What are dml triggers and types of dml triggers?
What do you understand by mirroring and mention the advantages of the mirroring?
How to get a list of all tables with "sys.tables" view in ms sql server?
What are the triggers in sql?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is data compression? : sql server database administration
What are the system database in sql server 2005?
What is difference between index seek vs. Index scan?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What does executeupdate return?
