foreign keys and indices
I have a script that was generated by a data modelling tool (ER Studio, I belive) to create a bunch of tables in oracle 11.1 DB. For most of the tables, the tool generates an index on any combination of the columns as long as there is a FK defined on these columns. For instance if my table has a primary key on columns col1, col2, col3, there will be a unique index on these three columns. If there is a FK on the columns col1 and col2, there will be another index on col1 and col2.
I do remember that a few versions back there was a requirement to index the columns that are part of a FK to preven oracle from locking tables, but this was probably version 8 or 9. I don't think that this is needed in oracle 11 (or 10 for that matter). Am I correct here?