Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38452 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / geeta
clustered index is an index that sorts and stores the data
rows in the tables based on their key values.the data is
physically sorted in the table when clustered index is
defined on it. only one clustered index is created per
table.
In Nonclustered index contains the indx key values and the
row locators that point the storage location of the data in
a table. there can be as many as 249 nonclustered indexs
per table.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is difference between count (*) and count column?
What is indexed view? How to create it?
How to create and drop temp table in sql server?
How to create hyperlink from returned sql query ?
what is unique and xaml nonclustered index
What is an active database?
List few advantages of stored procedure.
In which files does sql server actually store data?
What are the properties of primary key?
How to create dbo table in sql server?
How to delete existing rows in a table?
List down some advantages of sql stored procedure?
How do you Implement SSIS Packages in your Project?
How to Insert multiple rows with a single insert statement?
Explain different types of lock modes in sql server 2000?
