What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 36442 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
Which are the olap features?
What is constraints and its types?
What are the difference between clustered and a non-clustered index?
What is the report builder?
Can primary key be a foreign key?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Differentiate between ms sql server reporting services vs crystal reports?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What are the system database in sql server 2005?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How can you stop stored procedures from recompiling?
How can you find out which stored procedures are recompiling?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Explain what are the different index configurations a table can have?
