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 to move the cursor in scrollable resultset ?

561


How will you perform truncation using JDBC?

568


What is jdbc and odbc in java?

481


Is jdbc object oriented?

492


How many types of jdbc drivers are there?

543






What is createstatement method in java?

498


Why do we need a jdbcrowset like wrapper around resultset?

768


Explain about Join?

585


Where is jdbc url mysql?

490


How to test jdbc connection to sql server?

488


What is device controller?

507


What is an escape syntax?

520


What is an advantage of using the jdbc connection pool?

443


Which is best database for java?

513


Why resultset is used in java?

493