Difference between Cluster and Non-cluster index?

Answer Posted / prince

clustered index is hemanth index
and
non clustered index is non hemanth index

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 2 types of classifications of constraints in the sql server?

587


Can you explain what is indexed view? How to create it?

530


What is a file group?

623


Which Model uses the SET concept

585


How many replicas are maintained for each sql azure db?

106






Explain user defined functions?

618


Can you explain powershell included in sql server 2008?

503


What is a coalesce function?

667


Explain alternate key, candidate key and composite key in sql server?

523


Why we need to use secondry database file? though, we can do same work using primary database file also.

5772


How can we improve performance by using SQL Server profiler?

579


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

539


How to filter out duplications in the returning rows in ms sql server?

637


What does the update command do?

616


What are the steps to process a single select statement?

514