can we define indexes on a foreign key? Explain pros and
cons?
Answer / 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 |
What is the role of the jdbc drivermanager class?
preparedstatement p= new preparedstatement is it possible ?
10 Answers Fidelity, IBM, Infrasys,
what does batchUpdate does?
What is the jdbc rowset?
What is the difference between client and server database cursors?
What should be done for auto generating primary key id in a table ?
What are the different types of drivers under jdbc?
Write an sql to find all records having all numeric characters in a field ?
How a database driver can be loaded with jdbc 4.0 / java 6?
How do you insert images into database using jdbc?
Explain the different ways to register a driver?
What is JDBC Connection isolation levels?