Oracle Database

Common practices for the Oracle Database platform:

1. B-tree indexes are useful for queries that are highly selective, highly filtered on the column(s) that are indexed.
2. Do not use Oracle bitmap queries on Simphony or Reporting & Analytics. Bitmap queries are designed for nightly batch-loaded systems, not for either real-time operational systems or for real-time reporting.
3. Collect statistics each night.
4. Rebuild indexes monthly or perhaps even weekly.
5. As with any database, perform capacity planning based not on expected or average load, but on the once-a-year peak time.
6. It is crucial to keep your data correctly purged; failure to do so can slowly turn an operational transaction system into a multi-year historical reporting database.