teradata limits
SYSTEM Number of Data bases 4.2 Billion
Message length 1 MB
SQL request length 1 MB
Active transactions 2,048
Data Parcel Length 65,104
Parcels in one message 256[@more@]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 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 fields 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
Rows per table limited by space available
SESSION Spool Files 2048
Global Temporary Tables 1000
Volatile Temporary Tables 2000
Parallel steps performed ( If no channels) 20
Number of channels 10
(Redistribution across AMPs uses 4 channels,
Non prime Index (without redistribution) uses 2 channels)
Message length 1 MB
SQL request length 1 MB
Active transactions 2,048
Data Parcel Length 65,104
Parcels in one message 256[@more@]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 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 fields 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
Rows per table limited by space available
SESSION Spool Files 2048
Global Temporary Tables 1000
Volatile Temporary Tables 2000
Parallel steps performed ( If no channels) 20
Number of channels 10
(Redistribution across AMPs uses 4 channels,
Non prime Index (without redistribution) uses 2 channels)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16723161/viewspace-1022140/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 10g Limits - Logical Database LimitsOracle 10gMITDatabase
- teradata CASTAST
- Physical Database LimitsDatabaseMIT
- limits.hMIT
- Oracle Physical Database LimitsOracleDatabaseMIT
- Teradata SQL調優SQL
- Teradata基礎教程
- Teradata時間操作
- Teradata 時間函式函式
- Teradata資料壓縮
- nginx 修改 max open files limitsNginxMIT
- How To Change UNIX Process Resource LimitsMIT
- 如何殺掉Teradata的sessionSession
- Teradata物件簡寫對照物件
- Teradata自定義函式Replace函式
- Teradata的資料保護
- std::numeric_limits::max() std::numeric_limits::min()編譯錯誤MIT編譯
- 2Gb - File limits in Oracle(轉)MITOracle
- Oracle:/etc/security/limits.confOracleMIT
- 關於Teradata PI的總結
- Teradata 之top n與sample n
- Teradata TPT處理Unicode方法Unicode
- Teradata新特性之reset when使用
- Teradata的資料保護策略
- ASM - Scalability and Limits [ID 370921.1]ASMMIT
- Teradata 錯誤總結(持續更新。。。)
- AIX 修改系統檔案 /etc/security/limitsAIMIT
- linux動態修改 max user processes limitsLinuxMIT
- linux limits.conf配置說明LinuxMIT
- Set Tolerance Limits for Price Variance(ZZ Kanterwang)MIT
- 資料倉儲 - Teradata學習體會
- goldengate 12c對teradata的支援Go
- oracle連線teradata透明閘道器配置Oracle
- mysql報錯Changed limits: max_open_files: 5000MySqlMIT
- SharePoint Server 2010 & WorkFlow related LimitsServerMIT
- 關於linux 資源限制 limits.confLinuxMIT
- /etc/security/limits.conf 設定----ORACLE安裝MITOracle
- Teradata退出中國,您可以相信中國資料庫!資料庫