Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146978 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / p.karthick
clustered index is physically stored
a table can have 1 clustered index
non clustered index is logically stored
a table can have 249 non clustred index
| Is This Answer Correct ? | 193 Yes | 46 No |
Post New Answer View All Answers
What is the difference between dbcc indexdefrag and dbcc reindex?
How will you make an attribute not process? : sql server analysis services, ssas
Do you know clustered and non-clustered index?
How to delete all rows with truncate table statement in ms sql server?
How to drop an existing table with "drop table" statements in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Why the trigger fires multiple times in single login?
Explain the third normal form(3nf)?
Do you know what is rank function?
What kind of problems occurs if we do not implement proper locking strategy?
Do you know what is difference between index seek vs. Index scan?
What is attribute relationships, why we need it? : sql server analysis services, ssas
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How to drop existing indexes in ms sql server?
Can an entity have two primary keys?
