User Guide > Configuring Relational Data Sources > About Data Source Native Load Performance Options
 
About Data Source Native Load Performance Options
Most data sources have proprietary ways to optimize performance, and they are typically enabled by default. If TDV detects that your operation (for example, a direct SELECT or INSERT) can be made faster using a native loading option, TDV attempts to use it.
Depending on the data source type and the TDV feature you are using, native load performance options vary as follows.
Data Source Type
INSERT and SELECT
Caching and Data Ship Performance Options
DB2
Native load with INSERT and SELECT is supported.
• Native load with INSERT and SELECT
• Native and bulk load with LOAD utility
Microsoft SQL Server
• Bulk loading using BCP
Netezza
Native load with INSERT and SELECT is supported.
• Native load with INSERT and SELECT
• External tables
Oracle
 
• (Version 9 and 10) Native load with INSERT and SELECT. (Native load with DB link is not supported.)
• (Version 11) Database links
PostgreSQL (Greenplum)
 
• COPY
Sybase IQ
 
• Location
• iAnywhere JDBC driver
Teradata
Native load with INSERT and SELECT INTO is supported.
• Native load with INSERT and SELECT
• FastLoad/FastExport
Vertica
 
• Bulk load utility
• Export to another Vertica database
• Native load with INSERT and SELECT