PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

Latest

Teradata Join strategies

As a major RDBMS, Teradata supports several popular Teradata join strategies (or join methods), and has its own unique ways to accomplish the joins. The most common join strategies are: Product Join Merge Join Exclusion Join Hash Join Nested Join Each join strategy has its own pros and cons, and it's hard to say which one is the best, depending on different ...

Teradata Account, Profile and Role in Teradata

Teradata Account

The three things all sound like some mechanisms designed for "managing and administering" the database. But how? And what's the difference? Account Teradata Account is mainly designed for system accounting purpose. It can help analyze the system performance and usage, plan the capacity, and also for charge-back billing. One user can have multiple accounts, for different workload and ...

Stats !! Stats !! Stats !! | Teradata 14.0 new syntax: SHOW STATISTICS

Teradata STATS - Statistics is important in Teradata. What's more important is to get into details of statistics. Earlier releases of Teradata provided the only way to observe collected statistics at the table level by using HELP STATISTICS: HELP STATISTICS table1;  *** Help information returned. 2 rows.  *** Total elapsed time was 1 second. Date     Time     Unique Values        Column Names -------- ...

What does DBC mean in Teradata?

Teradata DBC

DBC is the superuser on Teradata database. But what does it mean?  DataBase Control? No. DataBase Console? Nope. DataBase of California? No way! Are you missing the sunshine? DataBase Connection? Wow, very close! Here's the answer: Data Base Computer. Yes, they didn't call it Database (a single word) at that time, but Data Base. This is a tough question. Because ...

Performance Data Collection & Important DBC Tables

Performance Monitoring

DBQL - Database Query Logging What is it? DBQL captures important information about queries that run on your system.  With DBQL, you can find out everything from who uses the most CPU and when, to which step in a particular query was skewed and how much CPU each step used, and tons more.  This information is critical ...

Important Query for Download ~~ DBA Must Have queries !!

Queries to Download Link for Download Converting Byte filed to Hexadecimal Converting Byte to Hexadecimal Accessrights reporting macro Accesright_Latin Accesright_unicode Collect Stats Report Stale Stats Report Debugging a procedure Debug a Proc Generate collect statistics statement Collect Stats Generate Script Stored Procedures - Cursor Processing Curson in Stored Proc Find the number of rows of all tables in a database? Count of Records in Table Pros and Cons of Stored Procedures Advantages ...

TERADATA SOFTWARE DOWNLOAD ( TRIAL VERSION SOFTWARE NOT FOR COMMERCIAL USE)

Teradata Download

TERADATA SOFTWARE DOWNLOAD Find publicly-available downloads from Teradata. Use the Display Downloads From sidebar on the right to browse, or select one of the popular downloads below. JDBC Driver Teradata Express ( VMware | EC2 ) DBQL Scripts JMS Universal Connector teradataR Teradata Studio | Teradata Studio Express OLE DB Provider Teradata XML Services Teradata Plug-in for Eclipse Oracle UDFs CLIv2 ( Windows | Linux | MP-RAS | Solaris | AIX | HP-UX ) TTU - Windows Install Teradata Wallet ( Windows | Linux | Solaris | AIX | HP-UX ) Teradata Mapping Manager Teradata Warehouse Miner Viewpoint PDK Aster Express for VMware Aster JDBC Driver Aster Client Tools Aster Analytics ...