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
Name the method, which is used to prepare a callablestatement.
How can you create jdbc statements?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
What are the different types of resultset?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
What does it mean to "materialize" data?
How do I set properties for a JDBC driver and where are the properties stored?
What does connection pooling mean ?
What does executeupdate return in java?
How vendor Naming registry supports JNDI?
Is jdbc part of j2ee?
Is odbc an api?
What is a jdbc url?
How do I insert/update records with some of the columns having NULL value?
What class.forname will do while loading drivers of jdbc?