Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10124 Views
- Satyam, I also Faced
- E-Mail Answers
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
Does full backup break log chain?
What does COMMIT command do?
What is the cartesian product of the table?
What is the difference between varchar and nvarchar datatypes?
What is conditional split?
Is a primary key unique?
What is equi join with example?
Why does sql studio use a single registered database repository? : sql server management studio
How to rebuild the master database?
What is best institute to Learn DotNET And SQL in chennai?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is a linked server in sql server?
What is the purpose of optimization?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is the difference between truncate and delete commands?
