Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146352 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / bala murugan28
IN SIMPLE WORDS,
CLUTER INDEX IS PHYSICALY STORED ONE.
NONCLUSTER INDEX IS LOGICALLY STORED ONE.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
List the different types of joins?
Why should we go for stored procedures? Why not direct queries?
What is key attribute?
What is the use of stored procedure?
How you can get the list of largest tables in a database?
What is Dependency Injection and provide example?
How to delete exactly duplicate records from a table?
In what sequence sql statement is processed?
What is transaction server auto commit?
Explain indexing and what are the advantages of it?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Why use triggers?
Can we update data in a view?
Define candidate key, alternate key, and composite key.
What are the built in functions in sql server?
