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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / jai

Answer Posted / jai

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell about MOM Tool(Microsoft Operator Manager)?

1897

What are scheduled tasks in sql server?

1060

How to find the source of a table in sql server?

977

List out the different types of locks available in sql server?

968

What programming language would you use to create embedded functions in ssrs?

181

What are the different SQL Server Versions you have worked on?

989

What is the use of set nocount on/off statement?

1075

What are drilldown reports?

150

What do you understand by the denormalisation?

937

Does index speed up select statements?

1002

Explain about Normalization?

1040

How to update values in a table with update statements in ms sql server?

988

List the different index configurations possible for a table?

923

How to turn off warning messages during php execution?

1023

Does sql server use t sql?

994