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
How can we execute stored procedures using callablestatement?
What are the benefits of PreparedStatement over Statement?
Why jdbc is used in java?
How can I manage special characters when I execute an insert query?
How do I insert/update records with some of the columns having NULL value?
Is jdbc connection secure?
Explain the two tier and three tier architecture of jdbc.
What is a java driver?
What is JDBC PreparedStatement?
In which ways is driver class is registered with drive manager?
What is drivermanager in java?
Name the method, which is used to prepare a callablestatement.
What is jdbc driver?
What is createstatement method in java?
What does jdbc setmaxrows method do?