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 are different parts of a url?
In JDBC, All the API?s are interfaces? Where is the actual implementation?
what is the difference between SENSITIVE and INSENSITIVE?
What is jdbc architecture in java?
Is oracle client required for jdbc connection?
What is Type-1 Driver and when this driver is used?
what does the method Class.forName returns?
What are static and dynamic queries?
What is getconnection method in java?
What is the use of JDBC DriverManager class?
How do you know which driver is connected to a database?
What is resultsetmetadata?