Index
A
- Access Module Processors (AMPs)
- about / Identifying skewness in joins
- recovering / Recovering AMP down, Getting ready, How to do it..., There's more...
- aggregate-table join index / How it works...
- application admins / Introduction
- archive HUT locks
- unlocking / Unlocking archive HUT locks, How it works...
- ARC utility / Backup and recovery
- ASE (Account String Expansion) / Creating user accounts
- AWT saturation
- resolving / Resolving AWT saturation, How to do it..., How it works..., There's more...
- Azure
- Teradata, using / Teradata on Azure, How to do it..., How it works...
B
- backup and recovery / Backup and recovery
- business process management (BPM) / Exploring ordered analytic functions
C
- CASE statements
- CLOB (Character Large Object) / Creating a join index to improve performance
- Columnar / Partitioning tables column wise
- connection
- defining / Defining a connection, How to do it...
- correlated subquery (CS)
- working with / Working with correlated subqueries, Getting ready, How to do it..., How it works...
- about / Working with correlated subqueries
- cost-based optimizer / Cost-based optimizer
- cover query / How it works...
- cross join / Eliminating product joins
- CROSS JOIN / Introduction
D
- data
- importing / Importing data, How to do it...
- importing, in Express / In Express
- exporting / Exporting data
- exporting, with Teradata Studio Express / How to do it
- loading, from flat to Teradata / Loading data from flat to Teradata, Getting ready, How to do it..., How it works..., There's more...
- loading, from database to another database / Loading data from a one Teradata Database to another, Getting ready, How to do it..., How it works...
- database computer (DBC)
- about / Unlocking the DBC
- unlocking / Unlocking the DBC, How it works..., There's more...
- Database Initialization Program (DIP) / Archiving data dictionary
- databases
- archiving / Archiving databases, Getting ready, How it works..., There's more...
- Data control language (DCL) / Introduction
- Data definition language (DDL) / Introduction
- data dictionary (DD)
- archiving / Archiving data dictionary , How to do it..., How it works...
- about / Archiving data dictionary
- Data manipulation language (DML) / Introduction
- data size
- shrinking / Shrinking your data size, How it works..., There's more...
- data warehouse
- DBC (database computer)
- about / Archiving data dictionary , Managing DBC space
- space, managing / Managing DBC space, How to do it..., There's more...
- dbscontrol parameter
- used, for displaying MaxParseTreeSegs database parameters / Insufficient memory to parse this request, How to do it..., There's more...
- used, for modifying MaxParseTreeSegs database parameters / Insufficient memory to parse this request, How to do it..., There's more...
- general fields / There's more...
- performance fields / There's more...
- filesystem fields / There's more...
- statistics / There's more...
- delete performance
- enhancing / Improving delete performance, How it works..., There's more...
E
- EQUI-JOIN / Introduction
- explain plan
- decoding / Decoding explain, How it works..., There's more...
- expression stats
- collecting / How to collect expression stats, How it works..., There's more...
- Extract, Transformation, Load ETL method / Introduction
F
- failure 7547
- resolving / Resolving failure 7547, How to do it..., There's more...
- FastLoad error 2652
- resolving / Resolving FastLoad error 2652, How to do it..., How it works...
- FastLoad script
- LOGON / There's more...
- DATABASE / There's more...
- BEGIN LOADING / There's more...
- SESSIONS / There's more...
- SLEEP / There's more...
- TENACITY / There's more...
- ERRLIMIT / There's more...
- ERRORFILES / There's more...
- CHECKPOINT / There's more...
- SET RECORD / There's more...
- DEFINE / There's more...
- FILE / There's more...
- INSERT / There's more...
- filters
- flex throttle / Changing and managing throttle
- FSG cache
- managing / Managing the FSG cache, How to do it..., There's more...
- FULL OUTER JOIN / Introduction
G
- globally distributed object (GDO) / How it works...
- global temporary tables (GTT) / How to do it..., How to do it...
H
- hash index
- creating, for performance enhancement / Creating a hash index to improve performance, Getting ready, How to do it..., How it works...
- Host Utility (HUT) locks / Unlocking archive HUT locks, How it works...
I
- IdColBatchSize / There's more...
- indexes
- about / Introduction
- primary indexes (PI) / Introduction
- partitioned primary index (PPI) / Introduction
- raw data extensions / Introduction
- Information of Things (IoT) / How it works...
- INNER JOIN / Introduction
- insert performance
J
- JavaScript Object Notation (JSON)
- experimenting with / Experimenting with JSON, How to do it..., How it works...
- join index (JI)
- creating, for performance enhancement / Creating a join index to improve performance, How to do it..., How it works...
- about / There's more...
- joins
- skewness, identifying / Identifying skewness in joins, Getting ready, How to do it..., There's more...
- columns, identifying / Identify the right columns for joins, Getting ready, How it works..., There's more...
K
- killer queries
- identifying, in viewpoint / Identifying killer queries in viewpoint, How to do it..., How it works..., There's more...
L
- left join
- about / Introduction
- enhancing / Improving left join, Getting ready, How it works...
- LEFT OUTER JOIN / Introduction
- LOB (Large Object) / Creating a join index to improve performance
- local AMP / There's more...
M
- MaxParseTreeSegs database parameters
- displaying, with dbscontrol parameter / Insufficient memory to parse this request, How to do it...
- modifying, with dbscontrol parameter / Insufficient memory to parse this request, How to do it...
- MERGE INTO
- performing / Performing MERGE INTO, How to do it..., How it works...
- MLOAD
- preliminary / Resolving MLOAD error 2571
- DML transaction phase / Resolving MLOAD error 2571
- acquisition phase / Resolving MLOAD error 2571
- application phase / Resolving MLOAD error 2571
- cleanup phase / Resolving MLOAD error 2571
- used, for upserting data / Upserting data using MLOAD, Getting ready, How to do it..., How it works...
- MLOAD error 2571
- resolving / Resolving MLOAD error 2571, There's more...
- monitoring / Introduction
- multi-column stats
- identifying / Identifying multi-column stats, How it works...
- multi-level partitioned primary index (ML-PPI) / Creating a partitioned primary index to improve performance
- MultiLoad
- using, to delete / Using MultiLoad to delete, Getting ready, How it works...
N
- network tuning / There's more...
- non-partitioned primary index / Creating a partitioned primary index to improve performance
O
- Object usage count (OUC) / There's more...
- OLAP functions
- Cumulative sum (CSUM) / There's more...
- Moving Average (MAVG) / There's more...
- RANK / There's more...
- MDIFF / There's more...
- Percent_Rank / There's more...
- OLTP (Online Transaction Processing) / Exploring ordered analytic functions
- Online Analytical Processing (OLAP) / Exploring ordered analytic functions
- optimized plans / How it works...
- ordered analytic functions
- Ordinary Sub Query / Working with correlated subqueries
P
- parsing engine (PE) / How it works..., How it works...
- partition primary index (PPI)
- about / Partitioning tables column wise, Archiving PPI tables, Creating a partitioned primary index to improve performance
- creating, for performance enhancement / Creating a partitioned primary index to improve performance, Getting ready, How it works..., There's more...
- password
- securing, with Teradata wallet / Securing passwords using Teradata Wallet
- securing, with Teradata Wallet / Getting ready, How it works...
- phantom
- investigating / Investigating phantom and leftover spool issues, There's more...
- PPI tables
- archiving / Archiving PPI tables, Getting ready, How to do it..., There's more...
- product join indicator (PJI) / How it works...
- product joins
- eliminating / Eliminating product joins, How it works..., There's more...
- profiles
- creating / Creating profiles and assigning them to users, How to do it..., There's more...
- assigning, to users / Creating profiles and assigning them to users, How to do it..., There's more...
Q
- queries
- writing / Writing queries, How it works..., There's more...
- SQLA, using / Using SQLA
- BTEQ, using in Windows / Using BTEQ in Windows
- executing / Querying efficiently, Getting ready, How to do it..., How it works...
- execution plan / Explain before executing queries, How to do it..., There's more...
- optimizing / Optimizing queries, How it works...
- query band
- using / Using query band, How it works...
- query builder
- building / Building a query builder
- in Express / Query builder in Express
- query issues
- resolving, with help / Using help and show to resolve query issues, How it works..., There's more...
- resolving, with show / Using help and show to resolve query issues, How it works..., There's more...
R
- RIGHT JOIN / Introduction
- RIGHT OUTER JOIN / Introduction
- ruleset
- defining / Defining a ruleset, How to do it..., How it works...
S
- scandisk
- performing, on system / Performing scandisk on the system, How to do it..., How it works...
- secondary index
- creating, for performance enhancement / Creating a secondary index to improve performance, How to do it..., How it works..., There's more...
- pros / How it works...
- cons / How it works...
- Secure Zone
- creating / Creating a Secure Zone, There's more...
- skew
- resolving, in database / Resolving skew in database, How to do it..., There's more...
- skewing data
- resolving / Resolving skewing data, Getting ready, How to do it..., There's more...
- skewness
- identifying, in joins / Identifying skewness in joins, Getting ready, How to do it..., There's more...
- sliding window / There's more...
- slow queries
- monitoring / Monitoring slow queries, How to do it..., There's more...
- slow system
- resolving / Resolving a slow or hung system, How to do it..., How it works...
- software tuning / There's more...
- sparse join index / How it works...
- spool issues
- investigating / Investigating phantom and leftover spool issues, There's more...
- spool space / Investigating phantom and leftover spool issues
- SQL Assistant (SQLA)
- setting up / Setting up Teradata SQLA, There's more...
- configuring / Configuring SQLA, How it works...
- about / How it works...
- using / Using SQLA
- statistics
- about / Introduction
- evolution / Evolution of statistics
- collecting / How to collect statistics, How it works...
- copying / How to copy statistics, There's more...
- stats
- identifying, for table / Identifying stats for a table, How to do it..., There's more...
- Structured query language (SQL) / Introduction
- Studio tool options
- using / Using Studio tool options
- supervisor window
- session, aborting / Aborting a session from the supervisor window, There's more...
- suspect queries
- identifying / Identifying suspect queries, How it works...
- system admins / Introduction
- system performance / Introduction
- system resources
- monitoring / Introduction
T
- tables
- column wise, partitioning / Partitioning tables column wise, How to do it..., How it works...
- restoring / Restoring a table, How to do it..., How it works...
- creating / Creating, copying, and dropping tables, How it works..., There's more...
- copying / Creating, copying, and dropping tables, How it works..., There's more...
- dropping / Creating, copying, and dropping tables, How it works..., There's more...
- TASM exception
- creating / Creating a TASM exception, How to do it..., How it works...
- TD system
- restarting / Restarting the TD system, How it works..., There's more...
- Teradata
- using, in Azure / Teradata on Azure, How to do it..., How it works...
- Teradata 15.10
- setting up / Setting up Teradata 15.10, How to do it...
- Teradata Active System Management (TASM) / Defining workloads based on application
- Teradata database
- creating / Creating a Teradata database, How to do it..., There's more...
- user, creating / Creating a Teradata database user, How it works...
- about / Introduction
- Teradata Intelligent Memory (TIM) / There's more...
- Teradata joins
- enhancing / Improving Teradata joins, How to do it..., How it works...
- Teradata Parallel Transporter (TPT) / Loading data from a one Teradata Database to another
- Teradata Studio Express
- setting up / Setting up Teradata Studio Express, How to do it...
- Teradata system
- connecting / Connecting to the Teradata system
- Studio tool options, using / Using Studio tool options
- Teradata viewpoint / How it works...
- Teradata Wallet
- used, for securing passwords / Securing passwords using Teradata Wallet
- used, for securing password / Getting ready, How it works...
- throttle
- modifying / Changing and managing throttle, How to do it..., How it works..., There's more...
- managing / Changing and managing throttle, How to do it..., How it works..., There's more...
- session throttle / Changing and managing throttle
- query throttle / Changing and managing throttle
- utility throttle / Changing and managing throttle
- TJ (transient journal) / Managing DBC space
- TTU / Getting ready
U
- UDT (User Defined Type) / Creating a join index to improve performance
- Unique Primary Indexes (UPI) / How it works...
- unique row number
- generating / Generating a unique row number, How to do it..., How it works...
- update performance
- enhancing / Improving update performance, How it works..., There's more...
- UPSERT / There's more...
- user accounts
- creating / Creating user accounts, How it works...
- utilities
- about / Introduction
- fastload / Introduction
- mload / Introduction
- fastexport / Introduction
- BTEQ / Introduction
- TPUMP / Introduction
V
- viewpoint
- killer queries, identifying / Identifying killer queries in viewpoint, How to do it..., How it works..., There's more...
- about / Identifying killer queries in viewpoint
- alerts, setting up / Setting up viewpoint alerts, How to do it..., How it works..., There's more...
- viewpoint portlet
- configuring / Configuring the viewpoint portlet, How to do it..., How it works...
- views
- working with / Working with views, How to do it..., How it works..., There's more...
W
- warning mode / There's more...
- workload
- defining, based on application / Defining workloads based on application, How to do it..., How it works..., There's more...
- classification criteria / Defining workloads based on application
- priority / Defining workloads based on application
- optional throttle settings / Defining workloads based on application
- optional service level goal (SLG) / Defining workloads based on application
- optional exceptions / Defining workloads based on application