When do you create cluster and noncluster index?
Answer Posted / krimish shah
Table can have only one clusert index. When we create
primary key on a table , it will generate a Cluster index
based on this primary key and physically sort and store the
data in order of clusterd index.
Non Cluster index are used to make search more effiecient
on table for given columns on which we have speicfied non
clustered index. Non cluster index have their own separate
storage.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Is sql server is free?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Does a sql server 2005 select statement require a from?
How to rebuild indexes with alter index ... Rebuild?
How to connect sql server management studio express to sql server 2005 express?
How many partitions a clustered index has by default in sql server 2012?
what are the new features in SSRS?
What is difference between createstatement and preparedstatement?
What happens on checkpoint?
Is sql server a database?
What is an indice?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to delete duplicate records based on single column from a table?
What is an expression in ms sql server?
What is CTE in SQL