# | Date | Forum | Type | Thread | Post |
7 | 29 Aug 2016 @ 01:05 PDT | Database | Reply | PPI | Thank you very much Todd.
I got it what i needed.
|
6 | 26 Aug 2016 @ 03:26 PDT | Database | Reply | PPI | Please comment..
|
5 | 24 Aug 2016 @ 10:03 PDT | Database | Reply | PPI | 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 ... |
4 | 04 Aug 2016 @ 10:38 PDT | Database | Reply | skew factor | Thenk 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 ... |
3 | 04 Aug 2016 @ 03:12 PDT | Database | Reply | skew factor | A NUPI column with high number of NULL result in high skew factor.
if yes then why ? as NULL cannot be compared with each other.
|
2 | 26 Jul 2016 @ 09:22 PDT | Database | Reply | What is difference between Redistribution of rows and Duplication of small table in AMPs | Thank 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 ... |
1 | 26 Jul 2016 @ 02:53 PDT | Database | Topic | What is difference between Redistribution of rows and Duplication of small table in AMPs | Related 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... |
|
|