What is the basic difference between clustered and a
non-clustered index?

Answer Posted / anil sharma

clustered index one in table nad non-clustered index may be
more than one in one table.

Is This Answer Correct ?    27 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are views used for?

778


Explain transaction server isolation?

740


How to modify an existing user defined function?

772


What are the differences between user defined functions and stored procedures?

737


How many databases Microsoft SQL server provides?

774






Is foreign key unique?

744


Explain the benefits of user-defined functions?

730


What is the name of the Database which IBM mainframe uses?

732


What do I need to start working with sql studio? : sql server management studio

804


Tell me what are the essential components of sql server service broker?

684


How to specify the collation for a character data type in ms sql server?

740


How to view existing indexes on an given table using sys.indexes?

800


What is the temp table?

698


What is an execution plan? How would you view the execution plan?

806


Explain what is lock escalation and what is its purpose?

679