Remote Table Optimization Process | Teradata Connector | QueryGrid - RTO Process - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem
When a query is sent from a Teradata system to a remote data source, and a push profile is used, the following occurs:
  1. The operation is sent to the remote data source.
    Statistics are collected. The statistics and push profile settings determine whether the operation is performed on the remote data source.
  2. A temporary table is created on the remote data source and the following scenarios apply:
    • If delayed fetch is enabled and chosen based on static statistics, dynamic statistics are collected for the temporary table. The statistics determine whether a remote join or local join is performed on the temporary table.
    • If a remote join is chosen (with or without delayed fetch), the temporary table is exported for a local join.
    QueryGrid creates temporary tables in the temporary database (or the default database if a temporary database is not provided). You must have CREATE TABLE and DROP TABLE access to the database.
  3. Statistics about the row count and byte count of the temporary table are collected and sent to the Teradata system optimizer for analysis.
  4. If the counts are at or below the delayed fetch threshold specified in the push profile, the query result (the temporary table) is sent to the Teradata system.
  5. If the byte count is greater than the delayed fetch threshold, the dynamic statistics that were collected are sent to the optimizer. The optimizer then decides whether a local join or remote join is performed.
    • If a local join is chosen, the temporary table is brought back in a separate execution phase.
    • If a remote join is chosen, the local table is exported, joined with the temporary table on the remote system, then brought back to the local system.