Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

Difference between clustered index and non-clustered index

Oct 26 2011 1:07AM by Ramireddy   

Question

What is there difference between clustered index and non-clustered index?

Answer

Important difference between these is, Clustered index consists of table data at leaf nodes, where as Non-Clustered index consists of pointer to the table row.

Another difference is regarding allowed indexes count, there will be only 1 CI per table. We can have upto 255 Non-CI until SQL Server 2005, From SQL Server 2008, limit increased to 999.

Read More..   [0 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"Difference between clustered index and non-clustered index" rated 5 out of 5 by 3 readers
Difference between clustered index and non-clustered index , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]