Difference between Cluster and Non-cluster index?
- 32 Answers
- 141586 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / sangram nayak
clustered index: if there is any primary key then then its clustered index.only one clustered index can be possible.
Non clusterd index: whenever you are creating any index on any column then that is non clustered index.multile non clusted index is possible.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the maximum length of an alert name?
What do you understand by the denormalisation?
Which are the important points to note when multilanguage data is stored in a table?
What is apply operator in sql?
How to apply cascading referential integrity in place of triggers?
What is the use of builtinadministrators group in sql server? : sql server security
How to provide values to user defined function parameters?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Define clusters?
how to avoid cursors? : Sql server database administration
What is sql server query analyzer?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How to add the custom code in Report?
Do you know query execution plan?
