Online Transaction Processing
- Few reads
- Many writes
- Many small transactions
- Look for redo/undo and sequential read issues
Decision Support/Data Warehouse
- Many reads
- Few writes (other then possible temp)
- Few transactions
- Look for sort/workarea and scattered read issues
Mixed or Hybrid
