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

How many databases can we create in a single server?

207


Is it possible for a stored procedure to call itself or recursive stored procedure?

947


What is SQL Azure?

107


How to throw custom exception in Stored Procedure?

1044


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

983


What does Master database contains?

1133


Can binary strings be used in arithmetical operations?

930


What is msdb database? : SQL Server Architecture

1127


Explain how to integrate the ssrs reports in application?

1009


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

915


Define magic tables in sql server?

1051


Benefits of Stored Procedures?

963


How to get nth highest salary from employee table.

1163


What is logshipping and its purpose?

990


How to create indexed view?

1041