Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38205 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 are the difficulties faced in cube development? : sql server analysis services, ssas
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
what are the different ways to return the rowcount of a table?
What happens if null values are involved in datetime operations?
What is an sql server agent?
What is the query and subquery?
How to encrypt data between dialogs?
What is the difference between seek predicate and predicate?
Do you know how to implement service broker?
What will be the maximum number of indexes per table?
What is the difference RDBMS and Graph Database?
What is the use of keyword with encryption.
Why use triggers?
what authentication modes does sql server support? : Sql server database administration
What is difference between aggregate and analytic function?
