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

what is cluster and nin-cluster index?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different type of Collation Sensitivity?

982


What is the difference between for xml raw and for xml auto?

1009


What is an example of a foreign key?

962


How to get the number of affected rows?

989


What are parameterized reports?

198


Explain following error properties?

997


Which is the latest version of sql server and when it is released?

1089


What is the order by used for?

1005


How do you debug a procedure in sql server?

925


How to skip remaining statements in a loop block using continue statements?

979


What are triggers? How do you invoke a trigger on demand?

1297


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1071


Define tempdb database?

978


Do you have any idea about the tcl commands?

947


What is a self join in sql server?

1110