#DateForumTypeThreadPost
620 Oct 2013 @ 09:03 PDTGeneralReplyCollecting StatsThanks for the reply aravind. How to validate the count has been increased or there's no change in the table. Thanks,      
512 Oct 2013 @ 11:02 PDTGeneralTopicCollecting StatsHi Guys, Please need your help in understanding when to collect stats. I know if the no. of count in a table is increased by 10%, we need to collect stats. How to validate the count has been inc...
409 Aug 2013 @ 01:34 PDTDatabaseTopicUSI VS NUSIHi Guys, Can please someone let  me know in which scenario we need to use USI and NUSI. 1 or 2 example would be great.   Thank you, Naveen  
304 Oct 2010 @ 06:56 PDTGeneralTopicETL jobs hangingHi, We do have a below update query, we do not have any PI or USI in WHERE clause. UPDATE target_table SET col_b = :a WHERE col_c = :ix; We do execute the above query from DataStage. ...
204 Oct 2010 @ 06:39 PDTToolsTopicETL jobs hangingHi, We do have a below update query, we do not have any PI or USI in WHERE clause. UPDATE target_table SET col_b = :a WHERE col_c = :ix; We do execute the above query from DataStage (ET...
113 Aug 2010 @ 06:00 PDTDatabaseTopicNo Primary Index (NoPI) Table in TD 13Hi, We do have lot of tables with skew factor up to 98%. We were thinking of using NoPI i.e. allowing a table with no primary index acting as a staging table, data can be loaded into the tabl...