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
What is user defined stored procedures?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is analysis service repository?
What is the dbcc command and why is it used?
What is cross join in sql server joins?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is a join in sql?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is the name of the Database which IBM mainframe uses?
What is an execution plan? When would you use it?
What are the operating modes in which database mirroring runs?
What is cursors? And what are the different types of cursor?
What are approximate numeric data types in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas