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

explain different levels of normalization? : Sql server database administration

0 Answers  

How many clustered indexes there can be on table ?

0 Answers  

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

What is primary key index?

0 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

How to delete duplicate rows?

0 Answers  

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

What is a SQL Server Temporary Table?

1 Answers   Wipro,

Explain about Joins?

0 Answers   Infosys,

Do you know what are the reporting services components?

0 Answers  

What is normalization of database?

0 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories