Few Ques

Database
Highlighted

Few Ques

Hi,
I am nwe to Tradata.
Can anybody tell me the followings:

***What is the maximum no of table joins supported by one TD query?

***What is the maximum no of rows can be scanned by a query?

****What is the maximum data size can be handled by single complex query?
3 REPLIES
Teradata Employee

Re: Few Ques

For this sort of information, check the System Limits appendix in the Database Design manual.

Maximum joins per query block = 64
No limit imposed by the system on number of rows scanned

Re: Few Ques

Thanks for your reply.
You said it 64 tables are allowed to be joined in a query.
Please let me know if it is the same for v2r6.............
Enthusiast

Re: Few Ques

No of tables allowed in a Select Statement
- V2R6 64

No of columns allowed in a Select Statement
- V2R6 1,024
- V2R5 256