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

Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does windows server 2016 come with sql server?

939


Do you know hot add cpu in sql server 2008?

958


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

959


What is difference between order by and group by?

1009


what are the three command line utilities and what are their primary functions?

147


Why variables called the most powerful component of ssis?

1082


What is the data type of time?

963


Define cross join in sql server joins?

1026


What is view in sql?

911


What are the advantages of paper records?

969


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1040


Explain alternate key, candidate key and composite key in sql server?

916


What is always encrypted?

1002


Write a SQL query to delete a table?

1142


What is difference between count (*) and count column?

908