Writing queries

Here we will assume that the reader is well versed with Teradata SQL syntax and has all the required tools to connect and execute the queries on Teradata.

Every SQL statement that executes on Teradata database consumes CPU, IO, AWT, and Spool.

Teradata's architecture is based on parallelism, which essentially means the efficiency of the query is based on how parallel efficient the query execution is, meaning how well it could leverage Teradata's parallelism. However, it also has an exception which will be covered in a later part of the chapter.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.