#DateForumTypeThreadPost
729 Aug 2016 @ 01:05 PDTDatabaseReplyPPIThank you very much Todd. I got it what i needed.  
626 Aug 2016 @ 03:26 PDTDatabaseReplyPPIPlease comment..
524 Aug 2016 @ 10:03 PDTDatabaseReplyPPI  CREATE MULTISET TABLE SUPPORTDB.TABLE1 (EMPNO INT,E_NAME VARCHAR(100),JOIN_DATE DATE ) UNIQUE PRIMARY INDEX (EMPNO) PARTITION BY RANGE_N (JOIN_DATE BETWEEN '2015-01-01' AND ...
404 Aug 2016 @ 10:38 PDTDatabaseReplyskew factorThenk you Pierre.. It happens some time when our database behave unexpectedly..   Even i checked practically and found that null values create same hash code ..so more nulls can cause high ...
304 Aug 2016 @ 03:12 PDTDatabaseReplyskew factorA NUPI column with high number of NULL result in high skew factor. if yes then  why ? as NULL cannot be compared with each other.
226 Jul 2016 @ 09:22 PDTDatabaseReplyWhat is difference between Redistribution of rows and Duplication of small table in AMPsThank you Sachin. 2nd point is also correct ? where TD duplicate the entire table (small table )on all AMPs. And also please tell me when the rows are redistributed or duplicated then where ...
126 Jul 2016 @ 02:53 PDTDatabaseTopicWhat is difference between Redistribution of rows and Duplication of small table in AMPsRelated to join strategy used by TD optimzer.   When we join table and see explain plain then  it show that rows are redistributed/duplicated on all AMPs based on join startegy use...