Difference between Cluster and Non-cluster index?

Answer Posted / 007

I agree with JAMESBOND's reply....thats the exact thing
happening behind the clustered index and non clustered
index. Remaining answers are all Cut and Paste....

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give main differences between "Truncate" and "Delete".

673


Why use stored procedures in sql server?

622


You want to implement the one-to-one relationship while designing tables. How would you do it?

624


How to delete an existing row with delete statements in ms sql server?

667


What is a field name?

620






what are defaults? : Sql server database administration

601


Determine when to use stored procedure to complete sql server tasks?

616


What is the maximum length of an alert name?

699


What is a rownum?

593


How to find which stored procedure is currently running in sql server?

574


What is advantage data architect?

607


How many types of objects are there?

592


Explain stored procedure?

684


How to modify an existing stored procedure in ms sql server?

638


What is the command used to check locks in microsoft sql server?

625