There is  "poetic query" that takes forever to run
Kind of looks like this
sel
col1.tb1,
col2,tb1,
(case <condition involving tb1 and tb2>) as "Dcol1",
Sum ( col1.tb3),
sum (col2.tb3 ),
sum (col3.tb3)
etc
from
tb1 left outer join tb2 <condition> LOJ tb3 <conditions>

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)

 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.
 

Hello All !
 
Wondering how Nodes & no. of AMPs effect the run of a query?
 For ex: if Non Prod Env has 10 Nodes but Prod env has 40 nodes.
How it'll effect the same query in both env's?
In that case will it be okay to tune the query in non-prod env?

SELECT
col1,col2
FROM
staging_table STG
INNER JOIN
target_table TGT
ON
STG.SRC_TRAN_ID=TGT.SRC_TRAN_ID
WHERE
TGT.ROW_STAT_CD='Active'
AND TGT.SRC_SYS='sourcename'
In above query, both STG and TGT has PI as SRC_TRAN_ID
TGT has stats collected on ROW_STAT_CD and SRC_SYS

Hello All !
 
I am bit new to Teradata and started working on it couple of months back.
 
I working on performance tuning suggestions for some new queries.
 
Wondering if anybody can help on:
How we can decide for the stats for new queries. I mean, the queries which are not in production yet.

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 .

Hi,
I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").

http://www.taubkin.de/workshop.html

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?

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

inner join small_table st
on...

or?:

select ...

from small_Table st

inner join medium_table mt
on...