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 the basic difference between clustered and a
non-clustered index?

Answer Posted / meera

Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.

Is This Answer Correct ?    9 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List some of the rules that apply to creating and using a ‘view’

814


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1065


What is a partitioned view?

948


Explain the various types of concurrency problem?

1135


What is xdr?

929


What are the export options of ssrs?

165


Do you know what are pages and extents? : SQL Server Architecture

941


What is NOT NULL Constraint in sql server 2012?

934


What are sp_configure commands and set commands?

956


What happens if null values are involved in string operations?

920


what are triggers? : Sql server database administration

862


What is sql injection and why is it a problem? : sql server security

1066


How to access the inserted record of an event?

989


How column data types are determined in a view?

897


How to use “drop” keyword in sql server and give an example?

1088