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

Explain the Ways to improve the performance of a sql azure database?

84


How you would rewrite the sql query to return the customerid sorted numerically?

1003


Will count(column) include columns with null values in its count?

1104


Explain the purpose of indexes?

982


Explain four layers of abstraction microsoft architectured?

147


How to make conditional sum in ssrs?

177


How much memory that we are using in Logshipping Concept?

1799


Can multiple columns be used in sql group by clause in ms sql server?

1055


How to add code to the existing article (using improve article)?

1115


How we can refresh the view?

1113


Explain an automatic checkpoint

977


What is sql language?

1153


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

951


How many replicas are maintained for each sql azure db?

124


How do indexes help, types?

969