Difference between Cluster and Non-cluster index?
- 32 Answers
- 142096 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar gupta
CLUSTERED INDEX:
Clustered index will be created by default when u
create primary key on a column. So we can create one
clustered index per table. clustered index is stored in
serial passion.
NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 141 Yes | 37 No |
Post New Answer View All Answers
You want to implement the one-to-one relationship while designing tables. How would you do it?
Write a program using SQL queries to find a unique entry in a table.
How to get nth highest salary from employee table.
Explain having clause and where clause?
If user is owning any SQL Objects, can we drop that user
Do you know what is sql injection?
What is the difference between a function and a trigger?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are different types of statements that are supported by sql?
What does null mean?
Explain error and transaction handling in sql server?
Which tcl commands are available on the sql server?
Explain microsoft sql server functions?
Define inner join? Explain with an example?
What is fill factor and pad index?
