The FastExport protocol is a Vantage feature that improves the performance of SELECT statements that meet certain criteria, enabling you to quickly retrieve large amounts of data. The exact difference in performance varies depending on the application and database configuration, and may be affected by the structure of the query. For example, FastExport works best for queries that do not include any GROUP BY or ORDER BY clauses.
- The table or view being queried does not include any data types that the FastExport protocol does not support. For example, BLOB and CLOB data are not supported.
- The query is being run as a prepared statement, using SQLPrepare and SQLExecute. SQLExecDirect queries are not supported.
- If the query is written as multiple semicolon-separated statements, the statements must all be SELECT statements.
Additionally, if you are running more than one prepared statement at the same time, the statements are subject to certain limitations. For more information, see "Restrictions and Limitations" in Teradata® FastExport Reference, B035-2410.
To configure the driver to use the FastExport protocol, set the following properties in your DSN or connection string. For more information, see Teradata DSN Options.
Key Name | Default Value | Required |
---|---|---|
Type | Default | No |
Sessions | None | No |