Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 37830 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 Sqlpaging in SqlServer 2005 ?
What is a join in sql? What are the types of joins?
SQL Server Architecture ?
what is the sql equivaent of the dataset relation object ?
How to create a user name in a database?
What is system stored procedures?
What is cdc in sql server?
How many replicas are maintained for each SQL Azure database?
Can select statements be used on views in ms sql server?
What is the purpose of the model database?
How to create a Master database in SQL server ?
What is the federation in sql azure?
What is query processing?
What is a collation in ms sql server?
Describe how to use linked server?
