Oracle Database
Common practices for the Oracle Database platform:
- B-tree indexes are useful for queries that are highly selective, highly filtered on the column(s) that are indexed.
- 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.
- Collect statistics each night.
- Rebuild indexes monthly or perhaps even weekly.
- As with any database, perform capacity planning based not on expected or average load, but on the once-a-year peak time.
- 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.
Parent topic: Database Options