# | Date | Where | Item | Comment |
7 | 28 Jan 2014 @ 06:45 PST | r.sagner's blog | Column compress values from statistics | Hi Nishant,
You are completely right. Only for the case that it would be good to compress only nulls and you want to write COMPRESS(NULL) the finding of the percentage of nulls makes sense. At the... |
6 | 27 Jan 2014 @ 05:01 PST | r.sagner's blog | Column compress values from statistics | Hi Nishant,
The number of nulls is never in the Biased values. In the output there is always an extra line with "NumOfNulls" (AWK Script Line 15). If the percentage of Nulls is relevant,... |
5 | 25 Dec 2013 @ 07:31 PST | r.sagner's blog | Column compress values from statistics | Hi all,
The first "Unfortunately": Unfortunately the data for the "show statistics values" command is stored in a blob called FieldStatistics in binary form to be easily read b... |
4 | 23 Dec 2013 @ 04:59 PST | r.sagner's blog | Column compress values from statistics |
Yes, you can reuse your algorithm for compression of columns. Only the typical time consuming "select col,count(*) from ..." at the beginning can be replaced by a millisecond oper... |
3 | 19 Dec 2013 @ 01:14 PST | r.sagner's blog | Column compress values from statistics | Thanks for the comment, on this position blog was not clear. What I want to say is that during the "alter table ... compress" statement it is not allowed to have statistics on the column ... |
2 | 31 Aug 2010 @ 12:16 PDT | Tools | FastLoad's useful -r option when loading a very large number of rows | Hi Thomas, Thanks for the very good article. Is this option introduced with 13.10? My HP-UX fastload version 13.0.0.5 don't know this option. Thanks, Roland |
1 | 30 Aug 2010 @ 09:41 PDT | Tools | FastLoad's useful -r option when loading a very large number of rows | Dear Thomas,
Can you tell me the disadvantages of this option when loading small files?
Thanks a lot
BR
Roland |
|
|