ETL Best Practices

  • Remove constraints and indexes from target table
  • Disable bitmap indexes during loads
  • Make even partitions
  • Pin some database objects to memory
  • Perform bulk loads
  • Increase block size from 16 K to 32 K
  • Remove unwanted columns from table
Advertisements