few Ques

Training

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?
6 REPLIES

Re: few Ques

Hi,

1) 64 table joins can be used in a query.

and sorry i am not sure about answer for other two questions

Regards,
Vasu
Enthusiast

Re: few Ques

I dont think the other 2 have any limits....
it will be restricted by the database size I guess...
:-)

Enthusiast

Re: few Ques

Teradata Maximums (V2R5.0)

--------------------------------------------------------------------------------
These are Limits in Teradata

System Limits

Number of Databases/Users 4.2 Billion
Message length 1 MB
SQL request length 1 MB
Number of Active transactions 2,048
Data Parcel Length 65,104
Parcels in one message 256
SQL title length 60
String constant length 255
Data Format Descriptor Length 30
Error message text in failure parcel 255
Sessions per gateway (Max 1 gateway / Node) 1,200
Sessions per PE 120
Concurrent Utility jobs 15
Vprocs per system 16,384
Vprocs per Node 128
Data capacity per AMP - Unformatted 1.3 Tbyte

Database Limits

Tables per database 32,000
Journal tables per database 1
Columns per table 2,048
LOB columns per table 32
Columns per View / Spool file 512
Block Size 130,560
Row size (approx) 64,256
Column size (approx) 64,000
LOB size 2 GB
Column / Table name length 30
Number of columns per index 62
Secondary / Join indexes per table 32
Table level constraints per table 100
Referential constraints per table 64
Tables that can reference a table 64
Columns in Foreign & Parent key 16
View / Macro nesting levels 8

N/A

Re: few Ques

Hi Praneet,

Number of Active transactions 2,048 -- Does this mean Teradata can have maximum of only 2048 transactions/queries run concurrently ?
Kos
N/A

Re: few Ques

Hi Praneet,

Do you have the limits for TD 13.10?

Thx,
KD
Junior Contributor

Re: few Ques

The limits for each release are listed in an appendix in the Database Design manual

Dieter