0 - 13 of 13 tags for performance tuning

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)

Here's a clever way to force the query optimizer to follow the same *stable* plan for a query regardless of the data set it runs against.  Useful when the data set cardinalities and row count profiles are well understood.  Also useful when ID numbers increase and the query optimizer would have to extrapolate past the right-most interval.

Hi,
I have below query which is failing in dev environment due to spool issue:
 
INSERT INTO D0_IM_RSTG_TAS_MD4.STG_TEMP_STOCK_DETAILS(MATERIAL_ID,
VALUATION_AREA_ID, PLANT_ID, STORAGE_LOCATION_ID, CUSTOMER_ID,
VENDOR_ID, WBS_ELEMENT_ID, FISCAL_PERIOD_CODE, BEGIN_DATE, END_DATE,

Everyone is taught how to collect statistics in order to make Teradata queries run well but what if you've collected all the statistics that you can and you STILL have bad performance?

Hi all,
I'm new in Teradata. I have learned the Teradata basics. However I don't know where to begin performance tuning topic. Are there any books you can recommend about the performace tuning issue? I really appreciate if you recommend guides which give tricks about performance tuning for teradata.
Thanks.

I have a long query generated from Microstrategy with lots of joins which was running our of spool space. I checked the query and confirmed that we had stats collected on all the join columns and stats were current. Then there was one column on which I dropped stats, it had both single and multi column stats after which the query started to run fine.

Hi All,
I have two tables lets say Tab1 with 1million records and Tab2 with 100million records.
Option 1) sel columns from tab1 inner join tab2
Option 2) sel columns from tab2 inner join tab1
Is option one better than option two? does it make a difference?

 
Hello Experts,
 
Can you please help me in tuning the below MERGE statement where both the tables have same PPI (loc_id, gnrc_item_id, gnrc_item_lvl_cd) having ~95 millions of records:-
 
 

MERGE INTO EDW_PR_WORK_DB.F_MOBILE_APP_TD_SLS AS TGT

USING EDW_PR_WORK_DB.SWM_SLS_AGG_NEW AS SRC

Hi all,

Performanc Tuning  

Utilizing Teradata’s Parallel Architecture:

Hi ,

I have a qry which is taking more cpu and skew is more. pls suggest how to tune this query.

Explain:

 

Explain SELECT

      WATR.BK_AS_PROJECT_TASK_NUM ,

      WATR.BK_AS_PROJECT_CD ,

Does Teradata capture the response time that it takes when a user opens the metadata within Teradata's SQL Assistant's Database Explore? 

Secondly, can Teradata be tuned to get better responses to these Database Explorer queries?