Data Ship Performance Optimization
The data ship optimization analyzes your queries to determine if performance gains can be realized. By temporarily transferring a small amount of data to a data source target, the native data source query optimizations can be used to significantly improve performance.
| • | About Data Ship |
| • | Data Ship Support and Requirements |
| • | Data Ship Limitations |
| • | Defining TDV Data Ship Configuration Parameters |
| • | Configuring Data Ship |
| — | Configuring Data Ship for DB2 |
| — | Configuring Data Ship Bulk Loading Option for DB2 |
| — | Configuring Data Ship for Microsoft SQL Server |
| — | Configuring Data Ship for Netezza |
| — | Configuring Data Ship for Oracle |
| — | Configuring Data Ship for Sybase IQ |
| — | Configuring Data Ship for Sybase IQ Targets with Location
|
| — | Configuring Data Ship for PostgreSQL and Vertica |
| • | Finishing Data Ship Configuration for Data Sources |
| • | Evaluating Queries for Data Ship Using Execution Plans |
| • | Using Time Series Functions for Vertica Data Ship Targets |
| • | Disabling Data Ship for Specific Query SQL |
| • | Managing Open Connection Threads |
| • | Using Data Ship for Prepared Statements
|
Subtopics