#DateForumTypeThreadPost
417 Nov 2014 @ 10:41 PSTDatabaseReplyHow to decide about Stats for new querieshi, For stats ensure they are laways up to date.As per teradata whenever there is 10% data change then we are supposed to update stats. to find out missing stats for querries use below EXPLAIN D...
320 May 2010 @ 06:36 PDTDatabaseReplyDesperately need ur help!Hi, I have not understood your question. Can you explain who the TASKS has values 100,101 in actual table?why the TEAM has value NULL?.What is input and what is required output,so we can think ab...
219 Apr 2010 @ 07:01 PDTGeneralReplyNeed clarification in PI.....Hi, See if you can define partition on LND_DEL_VOICE_DATA,in same way as DEL_VOICE_DATA also if you can introdue a new column in LND_DEL_VOICE_DATA for expression [cast(cast((a.dtstrtchrg (format ...
119 Apr 2010 @ 06:53 PDTToolsReplyDelete using MloadHi, Can you check whether the stats are collected on the partition column and column PARTITION? regards, Rupesh