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
What is the meaning of batch updates?
What are the main components of JDBC ?
What is odbc jdbc?
What is statement and resultset in jdbc?
What are types of jdbc drivers?
How to retrieve warnings in jdbc?
What class.forname will do while loading drivers of jdbc?
Why do we use jdbc in java?
What is ojdbc14 jar?
How can we execute stored procedures?
What is JDBC Savepoint? How to use it?
What is “dirty read” in JDBC? Which isolation level prevents dirty read?
How to test jdbc connection to sql server?
Explain the steps in writing a java program using jdbc?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?