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 |
How does a custom RowSetReader get called from a CachedRowSet?
What is the different between ResultSet and RowSet?
What are the packages are used in jdbc?
What is jdbc driver?
Why is jdbc needed?
can we define indexes on a foreign key? Explain pros and cons?
What are the sailent features of JDBC 2.0?
I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?
What is executeupdate in java?
What are the types of statements in jdbc?
What is jdbc driver in java?
Difference between JDBC and Hibernate? Give one sample based on the variance?