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

Latest

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 ...

Oracle to Teradata Migration Guideline

Oracle to Teradata

Oracle to Teradata Migration Guidelines Primary Index creation rules:  Oracle Teradata PRIMARY KEY Make UPI and change those columns to NOT NULL. No PRIMARY KEY but one or more UNIQUE indexes Create UPI with unique index with the least number of columns. Maintain NULL/NOT NULL constraint as is. No PRIMARY KEY, no Unique indexes, but only non-unique indexes Pick a good candidate for PI ...

Teradata Query Tuning and SQL Optimization

Optimization

Performance Optimization : Teradata makes itself the decision to use the index or not - if you are not careful you spend time in table updates to keep up an index which is no used at all (one cannot give the query optimizer hints to use some index - though collecting of statistics may affect the ...

Teradata SQL Assistant – An Overview

SQL Assistant

Teradata SQL Assistant is the SQL Editor which is most widely used to execute SQL queries on Teradata. The Teradata SQL Assistant has very easy to use GUI and it is far more comfortable to work on this editor than working on any other SQL Editor for Teradata. Teradata SQL Assistant has almost all the functionality which ...

Compression Techniques

compression

Teradata Compression Techniques Compression in Teradata plays a very important role in saving some space and increasing the performance of SQL Query. In Teradata, COMPRESSION can be implemented in three ways: a) Single Value or Multi Value Compression (MVC) b) Algorithmic Compression (ALC) c) Block – Level Compression (BLC) a) Single Value or Multi Value Compression: This type of compression is widely ...