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

If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

1055


How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

1066


What is the reason why we need a jdbcrowset like the wrapper around resultset?

1024


What is a jdbc driver and how many jdbc drivers are available?

1124


Discuss the procedure of retrieving warnings?

1035


Explain about the drive manager class working?

1181


What is database connection pooling? Advantages of using a connection pool?

1099


Which type of driver provides jdbc access via one or more odbc drivers?

945


How do I connect to jdbc?

985


Discuss the significances of jdbc.

964


What is JDBC RowSet? What are different types of RowSet?

1139


How can you make a connection?

1036


What does the jdbc connection interface?

1040


How to set the attribute concurrency in resultset?

972


How many categories of jdbc drivers are there?

964