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 define indexes on a foreign key? Explain pros and
cons?

Answer Posted / sangeeta

Yes,Ofcourse we can very well define indexes on a foreign
key but only the category - non clustered index. As
clustered index can be defined only on primary key.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we execute stored procedures using callablestatement?

942


What are the benefits of PreparedStatement over Statement?

1013


Why jdbc is used in java?

962


How can I manage special characters when I execute an insert query?

955


How do I insert/update records with some of the columns having NULL value?

951


Is jdbc connection secure?

962


Explain the two tier and three tier architecture of jdbc.

914


What is a java driver?

1022


What is JDBC PreparedStatement?

969


In which ways is driver class is registered with drive manager?

932


What is drivermanager in java?

959


Name the method, which is used to prepare a callablestatement.

916


What is jdbc driver?

912


What is createstatement method in java?

974


What does jdbc setmaxrows method do?

969