Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


diffrence between Cluster Index and non Cluster Index

Answers were Sorted based on User's Feedback



diffrence between Cluster Index and non Cluster Index..

Answer / naren

Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.

Is This Answer Correct ?    4 Yes 0 No

diffrence between Cluster Index and non Cluster Index..

Answer / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Is This Answer Correct ?    2 Yes 0 No

diffrence between Cluster Index and non Cluster Index..

Answer / indraneelandhavarapu

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the basic features of a trigger in ms sql server?

0 Answers  


Can you explain different types of locks in sql server?

0 Answers  


What is difference between drop truncate and delete?

0 Answers  


How to enable/disable indexes?

0 Answers  


Explain Capacity planning to create a database? and how to monitor it?

0 Answers  


What is transactional replication?

0 Answers  


What is dknf in normalization form?

0 Answers  


What is the difference between a view and a stored procedure?

0 Answers  


What are some examples of schemas?

0 Answers  


Explain what is public role in sql server?

0 Answers  


What is hot add cpu in sql server 2008?

0 Answers  


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  


Categories