Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38170 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 view in sql?
last function used in MS Access to convert sql what function will use in sql
How to get a list of columns using the "sys.columns" view in ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are joins in sql and what are the different types of joins?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is sql server schema compare? How we can compare two database schemas?
How can I change procedure name in sql server?
Difference between 2NF &3NF ?
Which autogrowth database setting is good?
What is the difference between for xml raw and for xml auto?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is coalesce in sql server?
Can sql servers linked to other servers?
Define primary key?
