Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10037 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
What is the use of keyword with encryption. Create a store procedure with encryption?
In which files does sql server actually store data?
what is a check constraint?
How would you choose between a clustered and a non-clustered index?
What is the difference RDBMS and Graph Database?
What does Master database contains?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What function does a database engine serve in the sql server?
How many database files are there in sql server 2000?what are they?
Disadvantages of the indexes?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
what is the difference between count(*) and count(1) ?
How to Update from select query in sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
