ITS - Information Systems

Oracle Indexing Standards

In order to obtain the best database performance with minimal tuning we have defined some standard indexes which should be created by every application developer as they develop new database tables.

1. Primary Keys:
   All our new databases should be using referential integrity, and as a result all Primary keys will have a unique key implicitly created when the primary key is created, so you should NOT have to create an index here manually.
2. Foreign Keys:
   Each foreign key should have its own non unique b-tree index created to support it. This will ensure that 95+% of queries and joins have sufficient indexes to avoid most table scans.