What is the basic difference between clustered and a
non-clustered index?
Answer Posted / santosh kumar
Index is Used for fast access the data.
Cluster Index is Unique in a table.One Table Contains Only
one Cluster Index but 249 Non Cluster Index is
Possible.Cluster Index is a Physical Storage and Non cluster
Index is a logical storage of the data.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
List all types of constraints in sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is the difference between left and right outer join?
What samples and sample databases are provided by microsoft?
If user is owning any SQL Objects, can we drop that user
Distinguish between commit and rollback?
What is the maximum length of an alert name?
How to create an index on a view?
What is the difference between function and stored procedure in sql server?
What is the difference between a "where" clause and a "having" clause?
What is the main purpose of having conversation group?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Give me any three differences between Truncate and Delete.
Explain the different types of backups available in sql server? : sql server database administration
What are the purposes and advantages stored procedure?