What is the basic difference between clustered and a
non-clustered index?
Answer Posted / s.purushothaman
The difference between a clustered index and a non-clustered index is that when you use a clustered index, the section of the table that comprises the index has its data pages linked differently from those data pages comprising a non-clustered index.
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
SQL Server Architecture ?
What authentication modes does sql server support?
Do you know how to make remote connection in database?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are “phantom rows”?
How to change the system date and time from SQL Plus Terminal ?
Explain activity monitors
What is the recommended total size of your memory optimized tables?
What is sql server profiler?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is query optimizer in sql server?
Why do we use functions?
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?