Datometry Documentation

Hyper-Q provides a query override feature that lets you register a custom query that will execute on the database when a client submits a specific input query. You use query override when the required performance cannot be achieved on the target database using standard optimization techniques, or by restructuring the original client query.

This guide contains the following sections:

About Hyper-Q SQL Hints Learn about Hyper-Q hints and how to apply them with different levels of specificity.

Table Creation Hints You can modify or override table creation properties for CREATE TABLE and CREATE TABLE AS SELECT (CTAS) SQL statements.

Indexing Hints Learn about Hyper-Q hints that allow you to modify how Teradata indexes are emulated by Hyper-Q on the destination data warehouse.

Statistics Collection Hints Statistics collection hints allow you to specify how Teradata statistics collection is emulated by Hyper-Q on Azure Synapse.

Query Statement and Expression Hints Hints Learn how to modify various types of query statements using Hyper-Q hints.

Data Type Hints Learn about Hyper-Q hints that allow you to accommodate differences between Teradata and Azure Synapse data types.

Load Data Hints Hyper-Q hints that help you load data more efficiently using tools and utilities such as Teradata FastLoad and Teradata MultiLoad.

Workload Management and Error Reporting Hints You can better manage workloads and error reporting using these Hyper-Q hints.