Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 9878 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
Explain system functions or built-in functions? What are different types of system functions?
How to loop through the result set with @@fetch_status?
Can we linked SharePoint to a SQL database?
What command would you use to create an index?
What is a transaction and why is it important?
Which tcp/ip port does sql server run on? How can it be changed?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to check status of stored procedure in sql server?
How to find the version of sql server? : sql server database administration
What are the difference between “where” and “having” clause in sql server?
Explain aggregate functions?
What is the need for indexing?
What are clustered and non-clustered index?
What are data files?
Does the unique constraint create an index?
