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

What is the sql case statement used for? Explain with an example?

0 Answers  

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

how do u find least salary in a table

4 Answers  

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

Where do you find the default Index fill factor and how to change it?

0 Answers  

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

Define inner join? Explain with an example?

0 Answers  

What do you mean by cardinality?

0 Answers  

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

What is row-level compre?

0 Answers  

what is curser.

9 Answers  

Why is the need for data conversion transformations?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories