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 can I write to the log used by DriverManager and JDBC drivers?
Can we return resultset in java?
Where can I find info, frameworks and example source for writing a JDBC driver?
What do you mean by odbc?
How to test jdbc connection to sql server?
What are the differences between resultset and rowset?
What is meant by jdbc and odbc?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
how many JDBC drivers ?name them?
What does executequery return in java?
How many categories of jdbc drivers are there?
what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?