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


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