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

what is cluster and nin-cluster index?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is cluster and nin-cluster index?..

Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Is This Answer Correct ?    9 Yes 0 No

what is cluster and nin-cluster index?..

Answer / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Is This Answer Correct ?    4 Yes 0 No

what is cluster and nin-cluster index?..

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Is This Answer Correct ?    5 Yes 2 No

what is cluster and nin-cluster index?..

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can you pass expressions to function parameters?

0 Answers  

How to list all user defined functions in the current database?

0 Answers  

What are dml triggers and types of dml triggers?

0 Answers  

How to get @@error and @@rowcount at the same time?

0 Answers  

Explain cursor as data base object?

0 Answers  

How do you start single user mode in clustered installations?

0 Answers  

How to write a query with a full outer join in ms sql server?

0 Answers  

What is log cache in sql server?

0 Answers  

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

What is optimization and its types?

0 Answers  

how insert selected column only ?

3 Answers   Robert Half,

When would you use a before or after trigger?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories