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

Can we create clustered index on non primary key column

Answer Posted / durgaprasad

no its not possible to place clustered index on non key
column once the table contains any one key column, bcoz key
column itself contains one clustered index based on that
data sorted in ascending order.if u place one more
clustered index how it is possible to arrange the data in
soreted order.

Is This Answer Correct ?    15 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of sql server agent windows service?

1029


Explain data warehousing in sql server?

988


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

172


What are the 2 types of classifications of constraints in the sql server?

1044


What can be used instead of trigger?

1097


Mention what are the different types of ssrs reports?

144


How to invoke a trigger on demand?

1027


What is nolock hint in sql server 2008

1072


What are views in ms sql server?

1023


Tell me what are cursors and when they are useful?

909


what are the new features introduced in sql server 2000? : Sql server database administration

871


How do I get to sql server configuration manager?

952


Explain what is lock escalation and what is its purpose?

874


Write a sql query to delete duplicate records from a table called table1

973


How to run queries with sql server management studio express?

1018