All Forums Database
Ashraf Arkesh 3 posts Joined 03/07
19 Mar 2007
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?

Fred 1096 posts Joined 08/04
20 Mar 2007

For this sort of information, check the System Limits appendix in the Database Design manual.Maximum joins per query block = 64No limit imposed by the system on number of rows scanned

Ashraf Arkesh 3 posts Joined 03/07
20 Mar 2007

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.............

Renji 17 posts Joined 08/05
27 Mar 2007

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

Regards
John Abraham

You must sign in to leave a comment.