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

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

542


How does recursive cte works in sql server?

532


Which joins are sql server default?

526


What is an indice?

582


What is sql server 2000 work load governor?

567






What is the beast way to write CTE in SQL Server ?

570


In which tcp/ip port does sql server run? Can it be changed?

568


What is the difference between varchar and nvarchar?

532


How is a full-text index updated?

550


what are database files and filegroups? : Sql server database administration

509


What do you understand by sql server agent?

542


Explain the advantages of merge replication?

524


What samples and sample databases are provided by microsoft?

583


List some advantages and disadvantages of stored procedure?

588


how to control the amount of free space in your index pages? : Sql server database administration

607