Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10098 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
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to configure odbc dsn with different port numbers?
Where can you find the error log information? : sql server database administration
what is sql server? : Sql server database administration
How to use old values to define new values in update statements in ms sql server?
What are triggers? How do you invoke a trigger on demand?
What is xdr?
What are the properties and different types of sub-queries?
How do you clear a log file?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How do I get to sql server configuration manager?
Do you know what are pages and extents? : SQL Server Architecture
What happens if you are trying to access a schema not owned by you?
What is a rollup clause?
What are null values in ms sql server?
