|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/20/2007 11:48:00 PM
Posts: 3,
Visits: 1
|
|
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?
Ashraf Arkesh Programmer
Software Serv
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/10/2007 3:15:00 AM
Posts: 3,
Visits: 1
|
|
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
thanks & Regards, Vasumathy
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/25/2008 12:53:07 PM
Posts: 118,
Visits: 60
|
|
I dont think the other 2 have any limits....
it will be restricted by the database size I guess...
:-)
Regards
Ramakrishna_Vedantam
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 5/4/2008 5:49:20 AM
Posts: 17,
Visits: 21
|
|
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
Praneet
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/15/2007 4:12:08 AM
Posts: 1,
Visits: 3
|
|
Hi Praneet,
Number of Active transactions 2,048 -- Does this mean Teradata can have maximum of only 2048 transactions/queries run concurrently ?
Shyju K,
India
|
|
|
|