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 / leelavinoth

I have created CLUSTERED on NON-PRIMARY Attribute because i
want my table has to be ordered in NON-PRIMARY column.
Because, most on my search and filtering will be on this
NON-PRIMARY column.

Is there any harm in this! Please recommend

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are two difference between sql azure and azure tables?

159


What are the differences between local and global temporary tables?

1023


System requirements for sql server 2005 express edition?

960


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

1043


Define union, union all, minus, intersect?

937


Explain about builtinadministrator?

1000


What is a cache in ssrs?

130


Can you name a few encryption mechanisms in sql server?

902


What is the difference between clustered index and primary key?

876


List the different types of joins?

937


What is an etl file?

910


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1911


What do you understand by mirroring and mention the advantages of the mirroring?

1016


What is use of dbcc commands?

1027


What are the different types of join?

1111