Difference between Cluster and Non-cluster index?
Answer Posted / sangram nayak
clustered index: if there is any primary key then then its clustered index.only one clustered index can be possible.
Non clusterd index: whenever you are creating any index on any column then that is non clustered index.multile non clusted index is possible.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to get a list of columns in a view using "sys.columns" in ms sql server?
How to stop a loop early with break statements in ms sql server?
How to use subqueries with the in operators in ms sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is implicit cursors?
What is tablesample?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is encryption key?
How to set the current database in ms sql server?
what purpose does the model database serve? : Sql server database administration
what are the different types of SSRS reports?
What is difference between sql and sql server?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is similarity and difference between truncate and delete in sql?
Do you know the isolation level that sql server support?