Maximum no. of tables in a query

Database
Enthusiast

Maximum no. of tables in a query

Hi,

Could anyone please tell me how many maximum number of tables or table instances can I include in a query. It will be helpful if you can be precise for V2R5 and V2R6.

Thanks.
1 REPLY
Senior Apprentice

Re: Maximum no. of tables in a query

Hi Alpesh,

SQL Reference: Fundamentals
Appendix C: Teradata Database Limits

Number of tables that can be joined per query block: 64

Same limit for V2R5 and V2R6

Dieter