Teradata Forums / Teradata / Training / few Ques / Latest Posts

RE: few Ques

kshyju — Thu, 15 Nov 2007 02:57:58 GMT

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

RE: few Ques

Praneet Kulkarni — Thu, 09 Aug 2007 05:08:16 GMT

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

RE: few Ques

ramakrishna_vedantam — Tue, 24 Apr 2007 08:39:32 GMT

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

RE: few Ques

vasumathy — Thu, 29 Mar 2007 10:43:04 GMT

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

few Ques

Ashraf Arkesh — Mon, 19 Mar 2007 07:20:46 GMT

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?