Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Using tempdb to Join Sybase or Microsoft SQL Server Tables

Using tempdb to Join Sybase or Microsoft SQL Server Tables

When you join large tables on a Sybase or Microsoft SQL Server database, it is possible to improve performance by creating the tempdb as an in-memory database to allocate sufficient memory. For more information, see the Sybase or Microsoft SQL Server documentation.