How Clustered Index and Non clustered index stored on SQL
server?

Answers were Sorted based on User's Feedback



How Clustered Index and Non clustered index stored on SQL server?..

Answer / anitha

clustered index that reorders the way in which records in
the table are physically stored.
non clustered index in which the logical order of the index

Is This Answer Correct ?    14 Yes 2 No

How Clustered Index and Non clustered index stored on SQL server?..

Answer / 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

More ASP.NET Interview Questions

What is the main difference between hash table and Dictionary?

3 Answers   CSC,


How Session use Cookies in State Management?

0 Answers  


What is & in a url?

0 Answers  


In a webpage if i want to give access to only half page ,then what should i do?

3 Answers  


Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process?

1 Answers   Patni, Perot Systems, Sedna Technology,






What are the memory-mapped files?

0 Answers  


Explain the difference between array and linkedlist?

0 Answers  


What is an application domain?

2 Answers   Microsoft,


What are sql notifications and sql invalidations?

0 Answers  


How to kill more than one session variables at a time

9 Answers   iSoft,


Define application state variable and session state variable?

0 Answers   UGC Corporation,


What are the advantages of using Master Pages?

0 Answers   MCN Solutions,


Categories