What do you mean by A non clustered index?

What do you mean by A non clustered index?

A Non Clustered Index is a special type of index, Which Indexes are in the logical order of the index, Its  does not match the physical stored order of the rows on disk. The leaf node does not consist of the data pages Which is from non clustered index. Instead, The leaf nodes contain index rows.

By:UMANG
Date:2010-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher