Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145948 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / chandu
Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.
Non-clustered index:
Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What are the properties of primary key?
What are acid properties of transaction?
What is federation member?
How to use order by with union operators in ms sql server?
What is molap and its advantage? : sql server analysis services, ssas
What is the difference between commit and rollback?
Is it possible to call a stored procedure within a stored procedure?
How will you make an attribute not process? : sql server analysis services, ssas
How to insert multiple rows with one insert statement in ms sql server?
What is the purpose of floor function?
What authentication modes does sql server support?
What is the contrast between sql and mysql?
What is a scheduled job or what is a scheduled task?
What is data source in connection string?
