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 / shailesh arban

Answer Posted / shailesh arban

Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute a sql statement using mssql_query()?

1054

Explain can SSRS reports Cache results?

158

What do we have to check in database testing?

1019

Explain full-text indexing?

985

What are the types of subquery?

1042

What is an index in a database?

979

How do I find the sql server database version?

1008

What is table level trigger?

1022

Can you please explain the difference between primary keys and foreign keys?

1110

Can you please explain the difference between function and stored procedure?

1007

Explain the relational database management system (rdbms)?

1098

How do I debug a stored procedure in sql server?

1109

Explain mixed authentication mode of sql server?

1064

How would you add a section to a table?

1049

Explain something about security and SQL Azure?

134