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 / santosh kumar

Index is Used for fast access the data.
Cluster Index is Unique in a table.One Table Contains Only
one Cluster Index but 249 Non Cluster Index is
Possible.Cluster Index is a Physical Storage and Non cluster
Index is a logical storage of the data.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you edit the .rdl code associated with a linked report?

149


Explain different types of collation sensitivity?

924


Does view occupy space?

885


What is wide table?

885


what is nonclustered index

897


Explain what is the function of sql server agent windows service?

942


How to get a list of columns in a view using "sys.columns" in ms sql server?

927


What is not null constraint?

1053


Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

993


How will you know when statistics on a table are obsolete?

1032


How to get a list all databases on the sql server?

1025


What is read committed?

1007


What are the steps you should follow to start sql server in single-user mode?

846


What are different backups available in sql server?

995


What is the use of =,==,=== operators?

957