Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10303 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
How do I schedule a sql server profiler trace?
What do you mean by sql server 2005 express management tools?
What is trigger in salesforce?
Is natural join and equi join same?
What is abstracting periodical?
What is inline table-value user-defined function?
Explain “row_number()” in sql server with an example?
Working with TLogs
How do you Implement SSIS Packages in your Project?
What is merge?
Tell me about the approaches which you used to counter the DI problems.
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What does nvl stand for?
What is the parse query button used for?
What the different components of Replication and what is their use?
