How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 7872 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / answerme
Clustered Index are always stored on disk in a certain
order i.e, the data on disk may well be stored in order of
the Primary Key. So the data retreival is faster, when
queried based on Primary key.
non Clustered indexes are all the other indexes on a table,
that do not dictate the order that records are stored on
disk.A non Clustered index stores all the fields that
comprise the index, plus a link to the actual full record
on disk. This link is the primary key (clustered index), so
in fact a non clustered index contains all the columns that
you specify for them plus the clustered index columns too.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is loop in asp.net?
Can you explain composite pattern?
What is difference between View State and Hidden Field in ASP.NET?
How does the service stream content?
What are sharepoint pages?
What is the use of execute non query in asp.net?
What is a postback ispostback and autopostback in asp net?
What is the use of the tag in the web.config file?
How to comment out asp.net tags?
What is http post action?
How can we identify that the Page is Post Back?
What is recordset asp?
What is app_code folder in asp net?
What are the disadvantages of asp.net?
What does passport and windows authentication mean in ASP.NET?
