#DateForumTypeThreadPost
301 Dec 2014 @ 05:35 PSTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???I have a table named TN_ORDERLINE_DEPENDENCY_TYPE_LNDG. None of its columns are more than 30 characters. I am able to create the table in one environment while it;s failing in other. Both the envir...
204 Nov 2012 @ 09:36 PSTDatabaseReplyPerformance Tuning Merge StatementHere is the explain plan for the same:-     1) First, we lock a distinct EDW_PR_WORK_DB."pseudo table" for read      on a RowHash to prevent global dead...
104 Nov 2012 @ 09:33 PSTDatabaseTopicPerformance Tuning Merge Statement  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 record...