Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38464 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 change the data type of an existing column with "alter table" statements in ms sql server?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is subquery? Explain the properties of a subquery?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain about system database?
How to configure odbc dsn with different port numbers?
Can you explain full-text query in sql server?
What have included columns when we talk about sql server indexing?
How do I open a .db file?
What are the dmvs?
What is the sql case statement used for? Explain with an example?
Can two tables share the same primary key?
Why use cursor in sql server?
What is repeatable read?
What is system stored procedures?
