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
How many databases can we create in a single server?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is SQL Azure?
How to throw custom exception in Stored Procedure?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What does Master database contains?
Can binary strings be used in arithmetical operations?
What is msdb database? : SQL Server Architecture
Explain how to integrate the ssrs reports in application?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Define magic tables in sql server?
Benefits of Stored Procedures?
How to get nth highest salary from employee table.
What is logshipping and its purpose?
How to create indexed view?