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 cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1328


What is the difference between clustered and a non-clustered index?

1074


What is SubQuery in SQL Server 2008

1070


Can we hide the definition of a stored procedure from a use?

1296


How do I view a stored procedure in sql server?

1032


How to execute stored procedure in select statement sql server?

1111


Why variables called the most powerful component of ssis?

1122


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

993


Why truncate is ddl command?

1111


What are the two authentication modes in sql server?

1167


What is recompile sql server?

1079


How retrieve field names from the table in SQL through JAVA code?

1954


How do I find query history in sql server?

987


What is the filtered index?

1106


What is normalization of database? What are its benefits?

1070