What is the basic difference between clustered and a
non-clustered index?
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Why do we backup Active Directory ?
what are database files and filegroups? : Sql server database administration
What is bcp? When does it used?
What happens if null values are involved in boolean operations?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is the fillfactor concept in indexes?
Explain where clause?
What is the difference between osql and query analyzer?
How to modify an existing user defined function?
What is a non clustered primary key?
How to find index size for each index on table?
What does man by sql wildcard characters in sql server?
What is 1nf 2nf and 3nf?
Explain what are sparse columns?
How many partitions a clustered index has by default in sql server 2012?