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

Latest

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

Correlated Subqueries Performance Tuning

Correlated Subquery - Performance Tuning A correlated subquery (CS) is a subquery whose outer query results are processed a row at a time, against the subquery result. The subquery result is computed for each row processed. a CS eliminates the need for intermediate or temporary tables a CS is fully integrated with global join planning to minimize costs CS ...

Teradata HeartBeat !! , Performance Analysis

Teradata Heartbeat

A heartbeat query can be any SQL statement run at specific intervals whose response time isbeing monitored. Measure response time as an indicator of system demand or system/database hangs Initiate an alert system if response time degrades so that you can take appropriate action Heartbeat queries are classified as System Production System Heartbeat Queries: Used to check overall system/database hangs, to react ...