![]() |
There is "poetic query" that takes forever to run
16 Sep 2015
| 2 comments
,
|
![]() |
Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.
DELETE FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID, AA.JOB_HEADER_ID,AA.JOB_LINE_NUM,AA.JOB_IDN) IN (SELECT JOB_ID,JOB_HEADER_ID,JOB_LINE_NUM,JOB_IDN FROM IMPORT_REFER_S BB GROUP BY 1,2,3,4)
28 Aug 2015
| 1 comment
,
|
![]() |
This session will discuss Application Query Tuning on the Teradata platform.
04 May 2015
,
|
![]() |
We are doing insert into select from source to back up table.Select part is running fine ,where are when doing insert it is taking time and using high CPU. Based on below parameters and explain,request you to provide suggestion for tuning.
06 Mar 2015
| 2 comments
,
|
![]() |
Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?
11 Feb 2015
,
|
![]() |
Hello All !
01 Dec 2014
| 4 comments
,
|
![]() |
SELECT
19 Nov 2014
| 4 comments
,
|
![]() |
SQL performance is vital for driving value from a data warehouse. With today's growing query complexity, optimizing SQL can be a daunting task ...
17 Nov 2014
,
|
![]() |
Hello All !
17 Nov 2014
| 28 comments
,
|
![]() |
Performance Diagnostic Method and Tools is targeted to uncover and resolve performance related issues in three primary areas...
06 Oct 2014
,
|
![]() |
Folks - if ANYONE out there wants to join me in getting access to TPN+ membership reply or IM me ( preferably if there, IM in the forum that is ) . I have been in Terdata world for a long time - technology has now changed drastically from what it used to be during V2R3/5/6 days .
10 Apr 2014
,
|
![]() |
Hi,
24 Apr 2013
,
|
![]() |
Have you ever struggled over whether, or how, to use a new database feature? In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.
03 Apr 2013
,
|
![]() |
|
![]() |
One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).
24 Aug 2011
,
|
![]() |
Have you ever been bewildered trying to tune complex Teradata queries that go on for pages and pages of EXPLAIN text? This presentation goes beyond "Explain the Explain", to teach strategies and techniques for quickly deciphering the most expensive operations in your queries. Taught by a 20+ year Teradata veteran, examples of real queries gathered from some of the largest production environments in the world are used. This is advanced material covered at a quick pace.
22 Apr 2011
| 1 comment
,
|
![]() |
When defining a PPI on a date column, would it be better to define your partitions so that fewer (and larger) partitions are accessed by the query or would it be better to define your partitions so that more (but smaller) partitions are accessed?
18 Nov 2010
| 2 comments
,
|
![]() |
This presentation will provide recommendations and guidelines for using leading practices to enable system and performance tuning. You will learn the benefits of using Teradata's most recent set of recommendations to manage workloads on a Teradata system. For example, by using Teradata's data collection guidelines, recommendations for Account Management and Logging, a user will be able to identify, analyze and tune problem queries for better performance. This presentation will also focus on how to use the tools provided in the Teradata Analyst Pak.
01 Nov 2010
,
|
![]() |
The primary goals in a successful backup strategy are to ensure backup integrity, minimize backup & restore time, & reduce impact on the Teradata system. This presentation covers the connection, configuration, & tuning of the BAR hardware and software components, protecting & validating backups, & how different backup strategies can be applied to reduce system impact.
21 Jun 2010
,
|
![]() |
Hi ALL, I have a simple question. Is it important the order of joind tables? What's better?: select ... from large_Table lt inner join medium_table mt inner join small_table st or?: select ... from small_Table st inner join medium_table mt
04 Mar 2010
| 2 comments
,
|