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

Why do we backup Active Directory ?

1037


what are database files and filegroups? : Sql server database administration

943


What is bcp? When does it used?

976


What happens if null values are involved in boolean operations?

985


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1060


What is the fillfactor concept in indexes?

976


Explain where clause?

985


What is the difference between osql and query analyzer?

988


How to modify an existing user defined function?

1099


What is a non clustered primary key?

920


How to find index size for each index on table?

998


What does man by sql wildcard characters in sql server?

1055


What is 1nf 2nf and 3nf?

887


Explain what are sparse columns?

988


How many partitions a clustered index has by default in sql server 2012?

1086