#DateForumTypeThreadPost
7407 Mar 2011 @ 08:39 PSTDatabaseTopicNot utilizing the PPI....Hi, The below part of the query is not using the PPI and it's going for the singel partition hash join..Code snippet is geiven below: INNER JOIN DP_VALMDM.PARTITION_KEY CBDT ON ( CB...
7318 Feb 2011 @ 09:28 PSTDatabaseReplyType Casting in Join...Thanks karam... Data is coming from flat file to staging table using Mload.In the staging table, all columns are VARCHAR data type..While processing from staging to XV ,cast conversion is happen...
7218 Feb 2011 @ 09:24 PSTDatabaseReplyConcatenation in INNER Join -Performance Issue...Can anyone help me on this?
7116 Feb 2011 @ 09:23 PSTDatabaseTopicType Casting in Join...Hi All, I have seen in most of the SQLs having Type cast conversion from varchar to interger and date to integer while processing from staging to next layer.. Code looks like: from stg...
7016 Feb 2011 @ 09:09 PSTDatabaseReplySuggestion for a query..Yeah..You are correct. When i checked the avg/max number of rows for each PI + Partition column combination is - 4 values per PI + per partition. DBQLExplaintbl is not enabled here...when i ...
6916 Feb 2011 @ 09:00 PSTDatabaseReplyConcatenation in INNER Join -Performance Issue...Yeah..Temporary table is a good idea to resolve this.. But i am taking EDW_KEY column from B0500 table.So,i need to join with B0500 table also right? or if we do this concatenation in Mload,wi...
6812 Feb 2011 @ 05:22 PSTDatabaseReplyConcatenation in INNER Join -Performance Issue...Currently,It's difficult to change the structure of DDL... Is there any other option instead of changin the DDL's structure? Thanks.
6712 Feb 2011 @ 02:08 PSTDatabaseReplycode check Hi, The cross join step is taking 47 seconds.. SELECT COALESCE(MAX(Ranked_Id),1) AS Max_Key FROM DP_TEDW.B0513_MAP Explain plan: Explanation 1) First, we lock DP_TEDW.B0500_KEY_EVENT ...
6611 Feb 2011 @ 05:09 PSTDatabaseReplycode check Hi, We are using TD12 version... 2.Collect stats. is upto date 3. Can you please help me out how to see the DBQL steps to determine the longest step (in DBQLsteptbl ,i see the s...
6510 Feb 2011 @ 09:03 PSTDatabaseTopiccode check Hi All, This query is taking more than 3 minutes .query is given below SELECT RANK(dt1.Source_Value) + dt2.Max_Key (INTEGER) AS Ranked_Id , '-'|| CAST(Ranked_Id AS CHAR(10)) (CHA...
6409 Feb 2011 @ 10:17 PSTDatabaseTopicConcatenation in INNER Join -Performance Issue...Hi all, The below query is taking 3 minutes to produce the result...The concatenation in the INNER JOIN condition is taking a long time and B0500 table is having 200 GB of data.. and S...
6308 Feb 2011 @ 09:27 PSTDatabaseReplySuggestion for a query..Yeah..End_dt is a PPI...Pls find the below average no. of records for your checking.. End_Dt Count(*) Avg. rows(%) ? 198676276 10.19 20/01/2010 118 0.00 21/01/2010 124 0.00 24/...
6205 Feb 2011 @ 06:58 PSTDatabaseReplySuggestion for a query..Explanation --------------------------------------------------------------------------- 1) First, we lock a distinct Dp_WEDW."pseudo table" for read on a RowHash to prevent global deadloc...
6126 Jan 2011 @ 01:38 PSTDatabaseReplySTJI is not using....Join Index is : Create Join Index Event_Partyid as Select party_id from Dp_Tedw.T0502_Event_Party Primary Index(Party_Id); Party_id is not an Index column,so i created STJI for Party_id ...
6026 Jan 2011 @ 01:29 PSTDatabaseReplySuggestion for a query..Hi Dieter, I'll post the explain plan on coming friday..Sorry for the delay....
5925 Jan 2011 @ 08:35 PSTDatabaseReplySTJI is not using....Anyone can help me to resolve this problem?
5824 Jan 2011 @ 08:33 PSTDatabaseTopicSTJI is not using....Hi, The below query INSERT SEL is running more than 1 hour daily..so i introduced Single table Join Index when we create for the column Party_id for the table Dp_TEDW.T0502_EVENT_PARTY... due t...
5721 Jan 2011 @ 03:31 PSTDatabaseReplySuggestion for a query..The column End_dt has 90% of NULL value..(we are using the condition End_dt is NULL in all the places )...Statistic is collected everyday (you may suggest if it's not required)..It's being used acr...
5621 Jan 2011 @ 03:10 PSTDatabaseReplyPerformance Tuning....Hi Dieter, I mentioned incorrectly about the Time_period column,it is Time_period='DY'.. Thank you so much for your reply..
5520 Jan 2011 @ 11:16 PSTDatabaseReplyPerformance Tuning....Anyone can help me on this?
5418 Jan 2011 @ 08:35 PSTDatabaseTopicSuggestion for a query..Hi All, In our queries,most of them are having the END_DT column and we are checking END_DT is null in most of the queries.. for example one query: SELECT S.Account_Num ,S.Account_...
5318 Jan 2011 @ 07:21 PSTDatabaseReplyPerformance Tuning....DDL is given below: CREATE SET TABLE DP_EDW.ACCT_BAL_DD ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( Account_Summary_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL, ...
5216 Jan 2011 @ 07:25 PSTDatabaseTopicPerformance Tuning....Hi, I have the below query which is running more than 1 hour and crunching the resources with high cpu skew. Query: SEL acct_num, acct_modified_num, acct_summary_dt, ...
5115 Jan 2011 @ 06:47 PSTDatabaseReplyLEFT OUTER instead of NOT IN...Hi Dieter, Thanks for your quick response.. Moreover,i have introduced the column "Ins_Txf_BatchID" as SI (secondary Index) but the above update query is not using the secondary index whe...
5013 Jan 2011 @ 03:50 PSTDatabaseReplyLEFT OUTER instead of NOT IN...Hi Dieter, After modifying the query as you suggested,it is using product join... Modified query is : UPDATE DD_TEDW.TX0305_ACCT_BAL_TYPE_DD_TWOPER SET End_Dt = (CAST ('201...

Pages