SQL Request and Response Limits - Teradata Database

Parameter

Value

Maximum SQL text size per request.

This includes SQL request text, USING data, and parcel overhead.

1 MB

Maximum number of entries in an IN list.

There is no fixed limit on the number of entries in an IN list; however, other limits such as the maximum SQL text size, place a request-specific upper bound on this number.

Unlimited

Maximum SQL activity count size.

8 bytes

Maximum number of tables and single‑table views that can be joined per query block.

This limit is controlled by the MaxJoinTables DBS Control parameter and the Cost Profile flags.

128

Maximum number of partitions for a hash join operation.

50

Maximum number of subquery nesting levels per query.

64

Maximum number of tables or single‑table views that can be referenced per subquery.

This limit is controlled by the MaxJoinTables DBS Control parameter and the Cost Profile flags.

128

Maximum number of fields in a USING row descriptor.

2,543

Maximum number of open cursors per embedded SQL program

16

Maximum SQL text response size.

1 MB

Maximum number of columns per DML request ORDER BY clause.

64

Maximum number of columns per DML request GROUP BY clause.

64

Maximum number of ORed conditions or IN list values per request

1,048,576

Maximum number of fields in a CONSTANT row

32,768