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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

diffrence between Cluster Index and non Cluster Index

Question Posted / katta_s

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  

For more SQL Server Interview Questions Click Here
Categories